State timeline, one row per state?

[bpeikes]

I’m about to lose my mind. The documentation states that you should be able to create a state timeline by returning one row per state start/stop.

I basically have a sql statement,

SELECT
   name AS metric,
   start_time AS time,
   end_time AS timeEnd,
   'Active' AS value
FROM xxxxxxx

All I get is two lines on the State Timeline, one called metric, and the other called value.

The documentation pretty much states that it supports one row per state change.

What am I doing wrong?

[dawiddebowski]

Hi, can you provide some context how your data looks e.g. as a table (toggle table view and cut off the sensitive data).

[bpeikes1]

metric is the name that we want for the row in the chart, like transaction_1253554, or transaction_1474773

value is processing

and start_time and end_time are exactly what you would think.

This works in the Gantt Chart , but documentation on Gantt Chart state it is no longer supported and to use State Timeline instead.

We basically want to be able to see times that jobs were running in a timeline.

[dawiddebowski]

Alright, so what I think you’d like to do is to use transformation Partition by values and partition it by the metric field (like in the screen). As for the other settings, I think you need to change Disconnect Values to Threshold (in my case it just kept going indefinitely). It also displayed weird label (not just linex), so you might want to go to Display name and type in ${__series.name}