Is there no way to display Performance Date and Time in one element, or to format Time as 12-hour? Date (even the entire "Performance Date" section) seems to have time separated from it, and the only time elements, Performance Detail > Time and Performance Detail > Hour are both 24-hour and have no formatting options (well, technically I can make Hour decimal...).
That correct Gawain,
For v15.x of Tessitura Analytics, very few "time" fields were included, and for those that were, 24-hour time was used to ensure proper sorting in the results. There was not at the time a supported "time" data type that would sort 12-hour time by period of day first. I expect in v16 to have a more robust date+time solution, hopefully across all fields that are currently just dates.
As it stands in v15.x, the best dimensional approach we have is a combination of PERFORMANCE DATE > Date in Days + PERFORMANCE DETAIL > Time. That said, if you'd be willing to share you specific uses cases, that helps ensure a) that if there's a workaround to get at what you ultimately need, we talk about that and b) those cases are considered during the analysis for v16 functionality.
Thanks,Chris
Chris Wallingford Product Owner Tessitura Network office: +1 888.643.5778 x553 chris.wallingford@tessituranetwork.com
Chris Wallingford said:As it stands in v15.x, the best dimensional approach we have is a combination of PERFORMANCE DATE > Date in Days + PERFORMANCE DETAIL > Time. That said, if you'd be willing to share you specific uses cases, that helps ensure a) that if there's a workaround to get at what you ultimately need, we talk about that and b) those cases are considered during the analysis for v16 functionality.
That is basically what I am doing right now, but what I am working on is designed as a customer-facing report, so I was hoping to get the sort but also the pretty display time (which I would have preferred in a single column). Is that something to consider on the date side as well, that is, if I format the date out backwards-American-style (Month-Day-Year) would sorting be mangled for multi-year data sets?
When using the "Date" type field for Performance Date, you can format the date as you like without losing the date-based sort.
The localization of your browser determines the default formatting for the date, which for me is backwards-American-style, and which sorts correctly.
Interesting: pity we can't have the time connected to the date.