Time based Calculation Visualisation issue

[amars]

Hi all,

We are working on a dashboard, where we try to find out the Average time Required to solve the Issues.

Now ideally an issue should be solved within minimum two consicutive working days, so that we will show the time taken for solving the issue in Hours:Min:Sec.

Now in a chart we are finding the amount of time taken, Divided by the total no of cases to find the average. And we format it as Time.

But for some cases the difference is going in few no of days, in which case when formating the expression as Time Format shows it as zero.

Please suggest any other alternative to handle such a situation.

Thanks in Advance.

Regards

Amar

[Jason_Michaelides]

Can you provide an example?

[amars]

Hi all,

Just to let you know , how I resolved the issue.

Now when you format a value as Time(Value), it is having a restriction of 24 hours if the value exceeds 24 hours. then it will show the value as Value - 24 Hours as HH:MM:SS (i.e if 30 Hours then it will show only 06:00:00).

Rather if you use Interval (Vlaue, 'HH:MM:SS') then the restriction of 24 hour will not be there and the Hour can take a value of whatever hours like 30:10:20 i.e. HH:MM:SS. That is if you use Interval to format a Time Vlaue then the restriction of 24 Hours can be suppressed.

Thanks. Hope this helps others.

Amar