Change expression format

[techvarun]

Hi

How to change the display format from date to time

Regards

[swuehl]

Have you tried changing the number format on Number tab in chart properties to interval?

[#3]

Hi

Within the object properties, simply go to the 'Number' tab and select time as below;

Let me know if that answers your question.

Regards

Steve

[techvarun]

Hi Steve & swuehl

     am getting right values on bar but i need to show the time values on the place which i have rounded on the attached image

Regards

[Anonymous]

use Dual function  something like this  dual (expression,num(exp ,'hh:MM:SS')

hope it helps

Sri

[PabloOrtiz]

Hi,

You have to create a calculate dimension.

Let me see the dataset you used.

[#7]

Please describe what the chart supposed to show to the user? If it is the average time, then convert your data to a specific unit, like hours or minutes before doing the averaging. Currently it looks like you used the Date format on the "Number" tab of the properties and specified 'h:m:s'.