hello everybody !
I try to create a graph from the table below :
it’s a MySQL datasource
I’ve created this request:
SELECT aggregatecapacityhistoryyearview.periodEndTime AS "time_sec", aggregatecapacityhistoryyearview.usedSum as "value", aggregate.name as "metric" FROM aggregatecapacityhistoryyearview join aggregate on aggregate.id = aggregatecapacityhistoryyearview.aggregateId WHERE aggregate.name not like "aggr_root%"
note : i’ve created a join section to replace aggregate ID by aggregate name
I get the graph below :
i’m not far but there are strange points in my graph, here an example:
I’ve tried group by aggregate.name, different macro for order but i really get troubles to finalize this query !
thanks a lot for your advices and help !