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.
Gawain — if you can get the date to display correctly or “good enough”, and your issue is just sorting, can I recommend a hidden column that relies on the RANK() or ORDER() function? I’ve posted on it before, but it’ll give you the ability to create a sort column (to hide, just color the text white and make the column narrow) based on as many parameters that you’d like to sort with (date, time, etc.). Very useful function for us vis-a-vis public dashboards.
DGomez
I've made the column black but making the text white - is that some Java magic?
Yep. Javascript / jQuery. I’ll post a sample dash tomorrow. You just target <td /> elements with a “fidx” attribute equal to the column number.
I’m not a fan of the script in this SiSense forum post (messy and bad variable naming conventions), but it’s instructive: support.sisense.com/.../360029461474-Pivot-widget-how-to-color-certain-columns-or-how-to-get-1-from-False-
messy and bad variable naming conventions
That has me written all over it. Thanks for this. I was talking to John J about this at TLCC last year. I have a vague memory or you mentioning this before ... but then again a lot of thing these days are vague memories
Here's a sample .dash, for the Javascript to format the CSS of any column. Further refinement can be made if you just want to target the header
$('td.p-dim-head[fidx='+fidxColumn+']');
or the rows
$('td.p-dim-member[fidx='+fidxColumn+']');
of the column.
SampleRowSort&ColumnText-Color.dash
Thank you my friend - that is indeed fantastic