Hi everyone ! I need some help to build a query.
I have the following query which returns average values with multiples series :
SELECT $__timeGroup(DateUTC,'1d', NULL) as time, Description as metric, AVG(VMActive) as value FROM "T_ACTIF" WHERE $__timeFilter(DateUTC) GROUP BY $__timeGroup(DateUTC,'1d', NULL),Description
Sample of data :
Instead of returning multiples series, I’d like to sum them (without using stack) into one value like this :
Can you help me to achieve this ?