Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
How to change the display format from date to time
Regards
Have you tried changing the number format on Number tab in chart properties to interval?
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
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
use Dual function something like this dual (expression,num(exp ,'hh:MM:SS')
hope it helps
Sri
Hi,
You have to create a calculate dimension.
Let me see the dataset you used.
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'.