Working with time values/measures
I was informed by Domo support that there is no accomodation for seconds-to-time in magic ETL. Doing this transformation in Beast Mode makes the time value a dimension, which I would not be able to perform calculations on. Is there any way around this? I am trying to make cards for call center metrics like average speed of answer, average hold times based on detail data, etc. All of the time values come from the database as seconds and I need to show them as time with trends and drilldowns. Any thoughts are appreciated.
0
Comments
-
I dont completely understand your problem but there is a way to work in seconds in Magic ETL.
Convert your DATETIME columns to decimal, the this converts time so 0 is 1/1/1970 and each unit equals 1 milisecond
0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 310 Workbench
- 7 Cloud Amplifier
- 9 Federated
- 3K Transform
- 113 SQL DataFlows
- 654 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 796 Beast Mode
- 78 App Studio
- 44 Variables
- 757 Automate
- 188 Apps
- 480 APIs & Domo Developer
- 72 Workflows
- 17 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 408 Distribute
- 119 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 141 Manage
- 137 Governance & Security
- 8 Domo Community Gallery
- 47 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive