Time Format in Pivot Chart ExpressionHe

[#1]

Hey everyone.

I am creating a Pivot Chart, but one of my expressions is Time (e.g. 01:00, 02:00 etc)

The problem is that it will show as Numeric instead of Time. (see screenshot)

I cannot seem to change this format to Time in the chart, it works perfectly in normal list boxes.

Any help is appreciated

and for a real challenge i refer you to my other post:

Grave mark in filepath --> ' <--

The person who can help me with that one deserves bonus points!

Kind Regards.

Mike Cleven

[MK_QSL · Accepted solution]

Try below calculated dimension

Time(Time#([Till Time],'h:mm:ss'))

[#3]

I tried it, but that didn't work.

However i tweaked it and made it =Time([Till Time],'h:mm:ss') and that works!

Thanks!