This content has been marked as final. Show 2 replies
I would like to show data by hour 12am - 12pm. The expression below works, but I would like to display the PM time as 1pm, 2pm, 3pm, etc. instead of 13pm, 14pm, 15pm, etc.
Any suggestions on how to update to adjust the timestamp for the PM hours?
Timestamp([Interaction Start Date Time UTC], 'h') & Timestamp([Interaction Start Date Time UTC],'TT')