A good tool for working with JSON data is https://json-csv.com It will convert the JSON to a CSV spreadsheet. CSV can then be opened in a spreadsheet where the data can be filtered, sorted, grouped and charted.