Hi All,
I am attempting to build out a basic dashboard to show the date, time, and total ticket count of a performance for front of house use. Currently the performance time is being shown as a 24 hour clock; I'd like to convert this to a 12 hour clock. However, because the "Performance Time" is a text variable, I'm not sure how to run any standard conversions.
Is there a recommended solution to this? Can the variable either be converted or altered at a dashboard level, or does the column need to be edited within the ElastiCube? In SSMS we generally refer to a performance date value, but in Analytics the performance dates all import with a time of 12:00:00AM.
Hi Matt,
For sorting purposes, the times are rendered in 24-hour format. This idea would add support for 12-hour AM/PM option.
(+) Enhance Tessitura Analytics date fields to include time - Ideas - Ideas - Tessitura Network