Unable to create an X-Axis Constant Line for a Time x-axis

[Lexola]

I have a timeseries line chart (see below), where the x-axis is Time datatype. 

The constant line feature does not allow for a time to be selected. When I try to add a conditional entry for the opening hour (08:00) the graph does not respond as expected (see below) and introduces dates onto the x-axis.

Thanks,

Lex

[GilbertQ]

Hi @Lexola 

Yes this should work as long as you have data for the time.

[Lexola]

Unfortunately, this doesn't work. I am also not able to set x-axis limits to show midnight to midnight for a day ( to keep the visual's x-axis the same when you change date filter.

Regards,

Lex

[Lexola]

Hi @GilbertQ,

Time is on the x-axis in my example (not a datetime). I do have data for many days though. So this should work whether I filter on just 1 day or on all days (and average across them).

[GilbertQ]

Hi @Lexola 

It could be because you have got the date/time and you only have data from a specific point in time?

What happens if you just put in the time on the X-axis and then filter it to be greater than 8AM does it then work?