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.