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.2K Product Ideas
- 1.2K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 273 Workbench
- 2 Cloud Amplifier
- 3 Federated
- 2.7K Transform
- 78 SQL DataFlows
- 526 Datasets
- 2.1K Magic ETL
- 3K Visualize
- 2.2K Charting
- 441 Beast Mode
- 23 Variables
- 514 Automate
- 115 Apps
- 391 APIs & Domo Developer
- 8 Workflows
- 26 Predict
- 10 Jupyter Workspaces
- 16 R & Python Tiles
- 332 Distribute
- 77 Domo Everywhere
- 255 Scheduled Reports
- 67 Manage
- 67 Governance & Security
- 1 Product Release Questions
- Community Forums
- 41 Getting Started
- 27 Community Member Introductions
- 68 Community Announcements
- 4.8K Archive