Allow date with time formatting in pivot tabel

[alexism]

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

[irismaessen]

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.

[tjswing]

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]

Hello @tjswing and @alexism,

Were you able to get this resolved with 2023.11?

[alexism]

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.

[Astroraf]

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

[tjswing]

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