How to show trend line between Date and timestamp

[varunreddy]

Hi All,

I am having the date field (YYYY-MM-DD hh:mm:ss) and I wanted to display the line chart with X-axis as Date (YYYY-MM-DD) and Y-axis as time stamp (hh:mm:ss). How can we achieve it and what will be the expression?

Thanks in advance,

Varun

[StarinieriG]

Hi,

try to use as dimensions:

Date(Timestamp#(field, 'YYYY-MM-DD hh:mm:ss'),'YYYY-MM-DD')

Time(Timestamp#(field, 'YYYY-MM-DD hh:mm:ss'),'hh:mm:ss')

[varunreddy]

What should be my expression?

[varunreddy]

I want to see timestamp in Y-Axis. On that day at that time I want to show the spike