This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Cookie Policy. Click Preferences to customize your cookie settings.
When Pivot or Table widgets, the options for formatting a datetime column allow showing the date OR the time, with no option to show both together (e.g. if format was "dd/MM/yyyy HH:mm:ss" then we could get "23/10/2022 17:05:21").
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.
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.
