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
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 470 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 193 Visualize
- 252 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 174 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive