Help With Beast Mode Calculation
I have a dataset that has the following Fields
Agent Name - Name of the agent
Agent Status= This is the state the agent was changed to . Available, Unavailable, Idle etc.
EventTime = Equals the timestamp that the agent status changed to
I need to calculate the time the agent was in that state, for example, Agent changed state to "unavailable" at 1:00 PM and then "Available" at 2:00 PM. So I should get back 1 hr as the unavailable time.
What I am struggling with is the eventtime field is all I have so I would need to subtract the time in between unavailable and available.
- 7.3K All Categories
- 13 Getting Started in the Community
- 141 Beastmode & Analytics
- 1.8K Data Platform & Data Science
- 54 Domo Everywhere
- 2K Charting
- 1K Ideas Exchange
- 903 Connectors
- 236 Workbench
- 342 APIs
- 77 Apps
- 19 Governance & Productivity
- 235 Use Cases & Best Practices
- 50 News
- 473 Onboarding
- 573 日本支部