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
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 656 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 811 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 80 App Studio
- 45 Variables
- 771 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 77 Workflows
- 23 Code Engine
- 36 AI and Machine Learning
- 19 AI Chat
- AI Playground
- AI Projects and Models
- 17 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 142 Manage
- 138 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive