Not able to Visualize in Pie chart using Grafana Dashboard and plugin as CSV

|CREATED_DATE|ID|STATUS|ID_TYPE|
|12-Apr-24|5-123456|Order Placed|Order|
|14-Apr-24|5-999999|Order Placed|Quote|
|14-Apr-24|1-13EJPU9|Converted|Lead|
|14-Apr-24|1-037733|Order Placed|Quote|

1 Like

what are you expecting the pie chart to look like?


It should appear like this

1 Like

@vijaydaresforyou on Grafana Play you can see examples of how pie charts are done, I recommend specifically looking at how the data is formatted that goes into them

https://play.grafana.org/d/ktMs4D6Mk/5-bar-charts-and-pie-charts?orgId=1&tab=query

You’re looking for pie charts that display numbers and relative percentage distribution, but that is not in your input data, which is just a list of orders that were placed. To make these pie charts, you’re going to need to aggregate your data into a set of counts. It looks like you’ve got pipe delimited text data, so what you might do is aggregate by ID_TYPE counts of the number of records you’ve got, and then put that data into a pie chart.

This can be done by investigating transformations in Grafana

Thanks Davidallen5, this is the data I am trying to Visualize.

CREATED_DATE ID STATUS ID_TYPE
12-Apr-24 5-6373373 Order Placed Order
14-Apr-24 5-467274 Order Placed Quote
14-Apr-24 1-16EJPU5 Converted Lead

using infinity plugin, and UQL query language

https://grafana.github.io/grafana-infinity-datasource/docs/uql

:fish: :fishing_pole_and_fish:

2 Likes

Thanks, how can we have multiple graphs in visualization as I have requested.

you create distinct panels within the dashboard

Thanks Yosiaz, how can we have distinct panel within the dashboard.

Then change each panel’s query