I am new in Grafana. Using infinity data source. The data set as follows. While selecting date range filter , the graph is populating properly but the mean is coming for whole data sets not for the data set which lies on selected time range.
Date,Total Energy Generation,Total Energy Production,Total Gas Consumption,Total Production,Total Energy Export,PAF,PLF
2024-11-01,704,700,5349,254,4,90,82.8
2024-11-02,706,705,5345,277,1,93,88.35
2024-11-03,706,701,5474,264,5,94,85.54
2024-11-04,708,704,5347,252,4,95,85.5
2024-11-05,714,703,5248,255,11,90,88.2
2024-11-06,718,702,5352,267,16,90,81.9
2024-11-07,720,701,5368,259,19,92,85.56
2024-11-08,715,701,5205,258,14,92,82.8
2024-11-09,709,703,5464,274,6,90,82.8
2024-11-10,716,701,5249,254,15,93,86.49
2024-11-11,707,702,5212,259,5,91,85.54
2024-11-12,707,701,5294,266,6,92,87.4
1 Like
Hello,
does adding a transformation “convert field type” to your field to “Time” works for you?
I think the infinity data source only retrieve felds as text and you have to transform all the non text fields to have the correct values.
Best regards,
Ginger
1 Like
how are you doing the mean calculation?