-
Collapse columns based on value
I have a set of Call data where each row contains similar information in all columns but creates a new row based on the "flow" of the call. For example: LinkedId Leg LegType MenuName MenuOption Initial Queue Namebos-z15-call3-1550235827.1062618leg 1Dial curc-iready-qbos-z15-call3-1550235827.1062618leg 2Answer…
-
Same Day Closure %
Hello, I am working on a way to figure out what the same-day closure rate % is for customer support cases created within X time frame. As well as compare that to a previous time frame. Example: Feb 2017 = 73% Feb 2018 = 90% March 2017 = 85% March 2018 = 88% I would like to see if there is a visual way of doing this as well…
-
Ignore filter on a calculated field
Hello, I'm wondering if it's possible to create a BeastMode that ignores date filtering... I have a dataset that contains the following information ID# CUSTOMERNAME STATE FullDate Logins Errors % The card I'm building should only display the data from yesterday BUT, I want to add a field that calculates how many times the…
-
Beast mode for custom year
I would like to create a custom year starting August 15th and ending August 14th. We work with schools and the August 15th date is typically week and day 1 for the "School Year" Is there a way I can take the date a case was created and convert it to be the day/week of the School Year?
