I’m new to canvas and I am having issues with inputting the metric values on the panel. For me the values show are only that of the last row and I’m having a hard time changing between rows. I would appreciate any advice.
An cancas element showes exacly one value. Do you have an example?
Here are two images, I don’t know if you are able to see them but the issue is that the metric value shown is consistently from the last row, and I am not sure how to change the row shown. When I choose the column Asset it can only display the last row, Asset J. My trouble stems from not being able to change that to a different row.
@ar65578 which row do you want to see and what is/are the criterion/criteria for showing the specific row you want from the data shown?
Also please share not an image of your data but text representation of it we can use to test it out in our local grafana
I want to be able to switch between rows on the values that I have present on my visualization. I can send the rows as numbers with the columns shown.
-
Asset: Asset A
Solar (kWh): 15000
Wind (kWh): 15000
Total Fuel (gallons): 8000
Water Consumption per Square Foot (gallons): 0.40 -
Asset: Asset B
Solar (kWh): 14000
Wind (kWh): 14000
Total Fuel (gallons): 7800
Water Consumption per Square Foot (gallons): 0.35 -
Asset: Asset C
Solar (kWh): 16000
Wind (kWh): 16000
Total Fuel (gallons): 8500
Water Consumption per Square Foot (gallons): 0.42 -
Asset: Asset D
Solar (kWh): 15500
Wind (kWh): 15500
Total Fuel (gallons): 8200
Water Consumption per Square Foot (gallons): 0.39 -
Asset: Asset E
Solar (kWh): 13500
Wind (kWh): 13500
Total Fuel (gallons): 7000
Water Consumption per Square Foot (gallons): 0.38 -
Asset: Asset F
Solar (kWh): 16000
Wind (kWh): 16000
Total Fuel (gallons): 9000
Water Consumption per Square Foot (gallons): 0.41 -
Asset: Asset G
Solar (kWh): 14500
Wind (kWh): 14500
Total Fuel (gallons): 7700
Water Consumption per Square Foot (gallons): 0.36 -
Asset: Asset H
Solar (kWh): 15000
Wind (kWh): 15000
Total Fuel (gallons): 8000
Water Consumption per Square Foot (gallons): 0.37 -
Asset: Asset I
Solar (kWh): 14000
Wind (kWh): 14000
Total Fuel (gallons): 7500
Water Consumption per Square Foot (gallons): 0.35 -
Asset: Asset J
Solar (kWh): 14000
Wind (kWh): 14500
Total Fuel (gallons): 7500
Water Consumption per Square Foot (gallons): 0.37
not sure I understand. you mean when you click on a value.in the list it shows in canvas?
also the data your provide should be useable straight into grafana as csv
Solar (kWh),Wind (kWh),Total Fuel (gallons),
15000,15000,8000
etc
When I input a metric value item, by default it will show the values of the last row. I am having trouble figuring out how to change the row values shown when I input a metric value item.
when you input what metric and where are you inputting it?
we need the data as csv , columns and rows
Solar (kWh),Wind (kWh),Total Fuel (gallons)
15000,15000,8000
When I right click the canvas panel there is an add background and add item option, when I click add item there is a metric value option and then there is a dropdown for different columns on the csv i.e. solar, wind, total fuel. All of these show the values from the same row which is the last one. I am inputting these values outside of the table view and on the image if that is more clear. Also here is the csv in the different format.
Asset,Solar (kWh),Wind (kWh),Total Fuel (gallons),Water Consumption per Square Foot (gallons)
Asset A,15000,15000,8000,0.40
Asset B,14000,14000,7800,0.35
Asset C,16000,16000,8500,0.42
Asset D,15500,15500,8200,0.39
Asset E,13500,13500,7000,0.38
Asset F,16000,16000,9000,0.41
Asset G,14500,14500,7700,0.36
Asset H,15000,15000,8000,0.37
Asset I,14000,14000,7500,0.35
Asset J,14000,14500,7500,0.37
1 Like
Yes, that would work well. Thank you. How did you set that up if you don’t mind, I am unfamiliar with that feature?
Using business variable plugin for the filter and
using infinity plugin datasource with uql to do
parse-csv
| where
https://grafana.github.io/grafana-infinity-datasource/docs/uql
https://grafana.github.io/grafana-infinity-datasource/docs/filters
2 Likes
Perfect. Thank you.
1 Like