How to Graph 2 timestamps together?

[richardouellett]

I can successfully graph the number widgets received by hour using received timestamp below.  I now want to (on the same graph) overlay ordered widgets using the ordered timestamp on the same graph.  Each record has an ordered and received timestamp format MM/DD/YYYY hh:mm.   Hour is calculated =hour(received timestamp)  =hour(ordered timestamp).

Going a bit crazy with this one… please help/advise.  Thanks!

[MarcoWedel · Accepted solution]

Hi,

you could implement a canonical date calendar like decribed here:

Canonical Date

hope this helps

regards

Marco

[richardouellett]

Marco, Thank you for providing this information.