how can I create a graph showing time? I need to show my numbers in minutes (or seconds)
Hello
I am trying to build a card that shows the total promo time I have available in an hour of programming. So, for example, at 6pm, I have 2:30mins available of promo time. When I graph this the minutes come out as a decimal. How can I graph and show data in minutes?
0
Comments
-
If you have access to the ETL, you could build in a new field for minutes. So if breaking up the promo field taking everything before the : and then multipling by 60, then take everything after : and add that straight up. So for this you'd have 150 seconds (I hope my math was right there...late night).
If you don't have access to the ETL, you could do the same thing in a beast mode calculation.
I hope that helps. - matt
0
This discussion has been closed.
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 310 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3K Transform
- 112 SQL DataFlows
- 650 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 790 Beast Mode
- 78 App Studio
- 43 Variables
- 752 Automate
- 187 Apps
- 477 APIs & Domo Developer
- 71 Workflows
- 17 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 407 Distribute
- 118 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 140 Manage
- 136 Governance & Security
- 8 Domo Community Gallery
- 47 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 113 Community Announcements
- 4.8K Archive