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