Allow date with time formatting in pivot tabel

Hello DRay, no, it hasn't been fixed for our use case as per the release notes it is only supported on live models, and we use elastic cubes.

I saw a solution for this in a demo. We couldn't use it at the time because it required the new Analytical Engine and we had a requirement for a feature that wasn't available on the new Analytical Engine. But our required feature is supposed to be coming to the Analytical Engine in the 2023-11 release, so now I just need to remember how to set it up again. I sent a note to my rep to remind me, but happy to share as soon as I hear back.

DRay & alexism - We have been migrating towards live cubes and it is available for them (as noted). I don't know why they didn't also enable support for it on elasticubes but it didn't get added there.

It is really inconvenient to have to split the datetime into date and then time. Also, we work with logs and having the option to display the seconds is a must. Certainly, Sisense could do better in this respect.

Additionally, it is difficult to sort by this datetime field all at once, not having to choose between sorting by date or time but having the option to sort by both at the same time.

Our workaround was to add the datetime as a float, add it to the table, use for sorting and then use Javascript to hide the column. In this regard, it would be great to have an option to hide a column without having to use code. We sometimes need to add a column just for the sake of not having fields in the pivot grouped, as this makes the sorting by other fields a bit problematic.

I worked around this in some cases by including a text field with the date+time as a string in addition to the actual datetime field. But it would be nice not to need to do that.

Hello tjswing and alexism,

Were you able to get this resolved with 2023.11?

DRay I am having an issue with this with a client and this really should already be a feature to display date and timestamp in a table widget.