Displaying Time in hours:Minutes:Seconds in Calendar

We track out contract processing time in seconds. I far as I can tell the only way to display the time in a calendar, Average Time per day for all locations is in seconds.
We want it to display as '0:07:52'
Any advice will be helpful.
Comments
-
Have you checked the idea exchange to see whether that idea has been suggested yet? I seem to remember this coming up before:
http://dojo.domo.com/t5/Ideas-How-would-you-make-Domo/idb-p/Ideas"When I have money, I buy books. When I have no money, I buy food." - Erasmus of Rotterdam0 -
There is a beast mode that converts a number to the format: sec_to_time(AVG(`columnname`)). This could be used in a table card to show the exact time component.
Unfortunately, I think you may lose your color differences if you use this in the card, because it may not be able to compare the resulting values.
Another possible view would be a simple line or bar chart that is graphed by day. This would show the differences day by day and would give an easier view into variation day by day. Is there a specific reason you need to use the calendar view and not another chart type?
**Say “Thanks" by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1 -
Unfortunately, that does not work.
0 -
Matthew, you may need to create/change the beast mode and then save the card. Sometimes when changing a beast mode, the actual results are not shown until the card is saved.0
-
Sadness
"When I have money, I buy books. When I have no money, I buy food." - Erasmus of Rotterdam0 -
Ok, I actually just tested this out for myself. It looks like we need to put the "Average Time" column as the "Event Name" and *not* put a column in for the "Event Value". I then saved the card and I'm able to see the time format for each day.0
-
still not what we are looking for
0 -
Unfortunately, it doesn't display the event name text on the page level. If you click on the card to see the card details, you'll be able to see the time-formatted values.0
-
No it does not does not display it on the card view or the list view
0 -
Can you share a screenshot of the card view? That's where I can see the time-formatted values on each day.1
-
Could you share a screenshot of what you see in those views?
"When I have money, I buy books. When I have no money, I buy food." - Erasmus of Rotterdam0
Categories
- 11.1K All Categories
- 5 Private Company Board
- 2 APAC User Group
- 12 Welcome
- 43 Domo News
- 10K Using Domo
- 2K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 350 Workbench
- 267 Domo Best Practices
- 13 Domo Certification
- 474 Domo Developer
- 51 Domo Everywhere
- 111 Apps
- 728 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 31 お知らせ
- 65 Kowaza
- 303 仲間に相談
- 664 ひらめき共有