We are using version 7.5.5 on Linux and connecting to SQL database.
I am trying to create a timeseries graph with multiple series.
The problem is the grouping: it is not calculating a month properly… is there anyway around it?
This is my query:
$__timeGroup(Posting_Date,‘1M’) as time,
SUM(Mat_Costs_Confir) as value,
b.Machine_Family as metric
a.Prod_Supervisor = b.Prod_Supervisor
b.Machine_Family IN ($parameter_Group)
And this is the result:
You can see the group is not a month exactly!!!