Displaying Time in hours:Minutes:Seconds in Calendar
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
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 99 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 728 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive