How to visualize data from local json files

Grafana Dashboards
1

Hello grafana gurus! I’ve never used grafana before, but my company uses it all the time to visualize data and I have a use case that I think is perfect, but I just can’t seem to get my data formatted/transformed the way I need. I have a bunch of JSON exports from API calls I’ve done at a customer every hour for a couple days, so they’re just local JSON files on my machine now (which I think may be part of the problem). The JSON files are in this format:

[{
        "name": "foo_1",
        "id": 3,
        "stats": {
            "aggregate_total_lines": 447464,
            "current_total_lines": 412547,
            "remaining_lines": 103054
        }
    }, {
        "name": "foo_2",
        "id": 83,
        "stats": {
            "aggregate_total_lines": 871750073,
            "current_total_lines": 169822988,
            "remaining_lines": 4632
        }
    }
]

There are ~400 foos in each one, and each one has the same foos but different numbers. I’d like to graph out each of those stats for each of the foos, so I can see the trend over time.

I’ve tried the Infinity plugin with a couple sample JSONs and although I can get the data in there as a table for each, I don’t know how to join the tables together based on each foo ID. I’m sure I’m missing something super obvious, but I just can’t seem to figure it out. Any advice would be greatly appreciated! Thanks!

2

I took your sample json, and just using a bar chart:

image
image1887×688 61.7 KB

I used the extract fields transformation, to break up the stats array into multiple fields, so those can then be charted as well, and i changed to x axis to be the id, so it would be grouped by foo id, just to give you some ideas…