How to see Average calls per Minute over the last 30 days?
I am importing data using a Federated Snowflake dataset. The dataset contains the following columns that I will use:
Call ID - the calls unique identifier
Date/Time - What time the call came in (dd/mm/yyyy - hh:mm:ss)
Call type - a category that states what the call was about
I am trying to see our average calls per minute when looking that the last 30 days. I can display this data when I am only looking at what came in during the last hour by counting the 'Call ID' column and then using 'Call Type' as a series:
But when I try to Avg(Count('Call ID')) using a beast mode (so that I can average the number of calls that came in each minute) it comes back with an error "we can't process this at this time..."
I imagine that I just don't know what I am doing. With it being a Federated Snowflake dataset, I don't believe I can do anything with the data via ETL, etc.
- 10.7K All Categories
- 13 Getting Started in the Community
- 41 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.5K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 303 Use Cases & Best Practices
- 503 APIs
- 120 Apps
- 48 News
- 753 Onboarding
- 1.2K 日本支部
- Private Company Board