This is a very basic query that I am trying to understand. I have a query for visualizing data in Grafana, that reads
SELECT mean("Value") FROM "3_weeks"."PROCESS" WHERE ("Name" = 'DC-bus voltage') AND $timeFilter GROUP BY time($__interval) fill(linear)
- What is the value of the variable
$__intervaland from where does it get its value?
- What is the significance of Grouping it by that interval and taking the mean? What if it was not grouped (I get the same graph)? Is it related to computational efficiency?