Page 1 of 1

Dashboard - Converting Seconds duration to HH:MM:SS format

Posted: Thu May 30, 2024 8:43 pm
by tbagby
I have an indicator on a dashboard that I would like to reflect the time duration. I have tried setting a custom text format on the box using the mask shown below, but on preview the indicator just shows the literal HH:mm:ss.
timeformatting.jpg
timeformatting.jpg (124.09 KiB) Viewed 20180 times
I also tried using the following code in a text editor on the dashboard, but it renders blank on preview. The "fsc_rep_CC_Perf_Inbound.TalkDurAvg" is a calculated column in my SQL connection.
{new TimeSpan(0,0,int.Parse(fsc_rep_CC_Perf_Inbound.TalkDurAvg))}

I found the above on ...
viewtopic.php?t=4642

Thanks!

Re: Dashboard - Converting Seconds duration to HH:MM:SS format

Posted: Fri May 31, 2024 11:42 am
by Lech Kulikowski
Hello,

Please send us a sample report with test data that reproduces the issue for analysis.

Thank you.

Re: Dashboard - Converting Seconds duration to HH:MM:SS format

Posted: Sun Jun 02, 2024 5:19 pm
by tbagby
I have attached a sample with indicators showing for seconds, formatted as time and formatted as custom mask. The last two are not working. Thank you for any insights.

Re: Dashboard - Converting Seconds duration to HH:MM:SS format

Posted: Tue Jun 04, 2024 2:24 pm
by Lech Kulikowski
Hello,

You can add a TimeSpan calculated column with the expression:
TimeSerial(0,0,Sheet1.Handle_Time)
the Sheet1.Handle_Time column should be the long type. And then use it in the Indicator.

Thank you.

Re: Dashboard - Converting Seconds duration to HH:MM:SS format

Posted: Tue Jun 04, 2024 7:49 pm
by tbagby
That works, thanks Lech!

Re: Dashboard - Converting Seconds duration to HH:MM:SS format

Posted: Wed Jun 05, 2024 9:29 pm
by Lech Kulikowski
Hello,

You are welcome.