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...).
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