Forum Discussion
Overlay variables line chart different datetimes
Hi Cas,
In the graph your all rows.value is a count of the values.
See if you can change that to your wanted summarisation in your graph values.
If that isn't possible change the data type in the query editor for the column.
Edit:
You can extract the minutes or seconds from the field to create a number field:
Assuming your data set looks as follows:
In query editor create a custom key that is unique for the run( source, metric, run)
Then we need the find the min date per run, and still be able to see all rows. Therefore we create a group by
We expand the AllRows column to have all rows including the mindate
From that we create a time substraction ( Datetime - mindate) to have the # minutes after the run has started.
With the minutes we can overlay all runs and the axis would be like
0 is starting time
1 is minutes after start.
This for every run.
Is this the kind of solution you are looking for?
Regards,
Mark
Hi Mark,
Thank you for you reply. Until the query editor it looks like your solution works perfectly. See the Substraction column:
The Data Type is Any. If I leave the Data Type as it is, I get this data after exiting the query editor:
If I make a chart I get this:
I think Data Type of Substraction should be Time instead of Any, but if I change it to Time I get an error. Do you know how to solve this or if I do something wrong?
Thank you and regards,
Cas
Hi Cas,
In the graph your all rows.value is a count of the values.
See if you can change that to your wanted summarisation in your graph values.
If that isn't possible change the data type in the query editor for the column.
Edit:
You can extract the minutes or seconds from the field to create a number field:Mark, thank you for your help!