How can I plot values that are in the time format mm:ss on a graph
I was able to use the SEC_TO_TIME function in DOMO to get my metrics on time duration in the format hh:mm:ss. However I am only able to see this data in a Table format. When I go to plot this on a graph it doesnt work. Any help in enabling this visualization would be great as we have many call center operations related metrics in this format like Average Handle Time, Average BOT Duration, Average First Response Time etc.
Answers
-
Hi @Meha, I don't think there's currently a way to visualise time in mm:ss format based on the default options. Perhaps there's a workaround that another user can offer.
In the meantime, I found this recent ideas request here [https://dojo.domo.com/discussion/53838/graphing-time-stamps-can-graph-mm-ss] that you can upvote.
9 -
Hi @Meha
Have you tried plotting the durations using the total number of seconds then having your beast mode with SEC_TO_TIME as a tooltip to the set your data label or hover text to that tooltip?
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2 -
@GrantSmith I haven't tried this let me give that a go. Thanks.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 302 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 104 SQL DataFlows
- 633 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 760 Beast Mode
- 62 App Studio
- 42 Variables
- 699 Automate
- 181 Apps
- 457 APIs & Domo Developer
- 51 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 401 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 8 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive