I have created a workspace on Amazon Managed Grafana and the version is v9.4.7
For datasource, I am using JSON plugin from Šimon Podlipský. I have implemented backend with three endpoints as mentioned in the documentation.
Datasource is connecting successfully to API endpoint.
For dashboard, I am using Canvas panel. In the API response for the Metric selected I get the data from the API end point. The data returned has list of values.
Below is a sample response for table.
[{"columns": [{"text": "Time", "type": "time"}, {"text": "Country", "type": "string"}, {"text": "Number", "type": "number"}], "rows": [[1234567, "BE", 123], [1234567, "GE", 231], [1234567, "PS", 321]], "type": "table"}]
When I select Country as an option in Field, the value shown is PS which is the value in last list. Currently I am not able to figure out what has to be done to plot other
values like BE and GE.
I have tried with timeseries data format as well. But here also I am seeing that last value in the list is selected.
How can I get to plot the other values? Is there any issue with the format of the response (table/timeseries) generated?
Any inputs in this regard will be really helpful. Thank you.