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
- 10.5K All Categories
- 3 Connect
- 913 Connectors
- 250 Workbench
- 458 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 183 Visualize
- 249 Beast Mode
- 2.1K Charting
- 11 Variables
- 16 Automate
- 354 APIs & Domo Developer
- 88 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 245 Distribute
- 62 Domo Everywhere
- 242 Scheduled Reports
- 20 Manage
- 41 Governance & Security
- 168 Product Ideas
- 1.2K Ideas Exchange
- 9 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive