-
Displaying Average of Data with Average of Each Part of the Series
Hello! I have two call types. Let's call them Inbound 1 and Inbound 2. I have a graph that doesn't distinguish between the two but averages both of their Handle Times into one line. I have another graph which displays their average Handle Times split into two lines, Inbound 1 and Inbound 2. I am looking for a way to see…
-
How to see which account has the greatest increase in activity
I have a card that looks at how many hours our operators spends on each customers account. The X axis has the account name/number and the y axis shows how many total hours we have spent over the time period (which for the card is year to date). The columns that we are using from the data set include: account name/number,…
-
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…
-
Date and Time - Looking at "Last Hour"
I am stumped and not sure where to go to try and figure this out. I have data being pushed into Domo where one of the columns contains date and time. I live in MST timezone. If I look at data from the "Last hour" it thinks that my last hour 7 hours in the future. How do I get my card to understand that my "Last hour" is…
-
Date Column importing incorrectly (subtracting a day)
I am using the Microsoft Sharepoint Online Connector to bring in some data from an excel file. I have a date column, that for whatever reason, comes into the DOMO datebase a day earlier than what is listed in the excel document. It has also added time to the date column. I have tried lots of different date formats to see…
-
Using two distinct data sets in one card
I have two datasets. The first has the dealers name with how many accounts they have. For example: Company nameTotal # AccountsCompany A1990Company B450Company C3000 The second shows all of the alarms for a given period and which account and dealer they are for. For example: Alarm DateAccount #Company…