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.8K All Categories
- 3 Private Company Board
- 1 APAC User Group
- 12 Welcome
- 39 Domo News
- 9.7K Using Domo
- 1.9K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 343 Workbench
- 260 Domo Best Practices
- 11 Domo Certification
- 465 Domo Developer
- 50 Domo Everywhere
- 106 Apps
- 717 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 27 お知らせ
- 64 Kowaza
- 299 仲間に相談
- 654 ひらめき共有