Unable to visualize my data correctly

Grafana
1

I have the following CSV data. For now, I’m using the Infinity CSV data source and manually providing the data inline until I host it at a url.

Month,Urgent,Critical,Serious,Medium,Minimal
Jan,,,,,
Feb,2,15,109,114,20
Mar,2,15,110,112,10
Apr,2,27,219,174,27
May,2,17,172,161,27
Jun,2,26,134,123,29
Jul,,,,,
Aug,,,,,
Sep,,,,,
Oct,,,,,
Nov,,,,,
Dec,,,,,

I want to visualize the data as a stacked bar graph. I wish I could share images to show you.

Issues:

  1. Grafana doesn’t display the visualization because there is no numeric data. I have to define each field in the parsing options. Is there a way I can specify this in the CSV?
  2. Grafana is sorting the columns alphabetically and I want them to appear in the order they are in the CSV.
  3. I want the data stacked with the most important data on the bottom. Bottom up it should be Urgent, Critical, Serious, Medium, Minimal
  4. I would like to specify the colour for each field
  5. Grafana sorts the legend alphabetically, I would like to specify the order of the legend (again, in the order it appears in the CSV)

Hereare sample images in PowerPointg (how I sould like) and Grafana.

image_720
image_720720×405 17.9 KB

image_480
image_480480×236 21.2 KB

2

Notice the use of Field Override to control color

image
image1314×461 40.7 KB

If you use UQL it keeps the sort intact

parse-csv
1 Like
3

image
image3456×1812 510 KB

If you want to use backend parser. Stacking set to normal

1 Like
4

I’ve been able to manually define each field… and specify as numeric. This creates the chart. I’ve overridden the colours now. Trying to do the sort now but not sure about UQL yet.

5

You’re saying change from CSV to UQL? I get an error that UQL does not support backend operations.

6

image
image887×400 27.2 KB

image
image874×365 18.8 KB

7

please open another thread for this? that is just a notification, does not mean it is not working.