Alteryx Auto Insights Discussions

Find answers, ask questions, and share expertise about Alteryx Auto Insights
Get started with

Alteryx Auto Insights

Lesson 1

Introduction to Alteryx Auto Insights

Lesson 2

Understanding Data with Alteryx Auto Insights

SOLVED

Custom Measures denominator across whole dataset, rather than by segment

KieranAdair
7 - Meteor

Has anyone had much luck setting up something like this in Auto-Insights:

 

Let's say you've got a KPI based on a pass/fail rating for each record in your dataset, and the measure is a count of records that failed/count of all records.

 

Example: % Phone calls answered within 30 seconds

Custom Measure: Numerator = Count(# Record where call was answered after 30 seconds),  Denominator = Count(All records)*

 

*I've followed the guidance and set these up in a table in the following way with a Numerator column (1 if True) and Denominator column (1), then in AAI made the Customer Measure SUM(N)/SUM(D)

 

Record IDLocationAnswered in 30 seconds  YNN ReasonNumeratorDenominator
aSydneyY 01
bSydneyY 01
cSydneyNNo available operators11
dSydneyNNo available operators11
eSydneyNAfter hours call11
fMelbourneY 01
gMelbourneY 01
hMelbourneNAfter hours call11

 

I can break this down across the Location segment: Sydney = 60% (3/5); Melbourne = 33% (1/3).

 

However, if I want to understand the N Reason Segment I get some weird results: No available operators = 100% (2/2); After hours call = 100% (2/2)

 

What I'd like is for the customer measure to take the count of the denominator from the entire table, while keeping the numerator as just the segment to get a balanced idea of the drivers of negative performance: No available operators = 20% (2/8), After hours call = 20% (2/8).

 

Anyone had luck configuring this? For now I've just set up a page in the mission to use count of trues rather than reporting on %s.

5 REPLIES 5
bradshaw
Alteryx
Alteryx

Hi @KieranAdair, you should be able to get the overall percentage of "N Reason" by doing a query of "Number of Record ID" with breakdown of "N Reason" which will show that both "No operators available" and "After hours calls" account for 25% of total, with "Unknown" accounting for the other 50%. Although not sure whether this is any better than your solution of counting TRUE's.

 

Screenshot 2024-08-07 at 3.14.41 PM.png

amelia_alteryx
Alteryx
Alteryx

Hi @KieranAdair 

 

To add to Brad's response, if the numerator is relevant (i.e. you want "After hours call" AND numerator = 1), here's another way you can achieve the solution:

  1. Create/convert your numerator into a segment. I called mine "Seg Numerator".
  2.  Your Mission query bar will have "Number of Record ID" as the measure, and "After hours call" and "1" as the filters. The key call out in the totals view will give you the % proportion (25% in this scenario)
  3. Repeat step 2 for "No available operators" and "1"

If the numerator isn't relevant or will always be "1", then Brad's solution is more efficient. Hope this helps!

 

Dataset:

data.png

 

Query bar:

query.png

Insight callout:

result.png

 

 

KieranAdair
7 - Meteor

Ah great, that makes a lot of sense - thank you Brad and Amelia!

 

I think the issue might be that I'm trying to have two pages which show something like this:

 

Page 1 - % Phone calls answered within 30 second

 

DateWeek 1Week 2Week 3Week 4Week 5Week 6
Result10%10%10%12%15%6%

 

Page 2 - Miss driver breakdowns

 

DateWeek 1Week 2Week 3Week 4Week 5Week 6
No Available Operators6%10%8%8%10%4%
After Hours Calls4%0%2%4%5%2%

 

And trying to display the WoW % change in drivers (ie. After Hours Calls increased by x points this week) rather than the WoW volume changes as the number of calls may differ.

 

I think though that this might not be an idea use case for AII at present, and that brad's solution to show the index count/breakdown might be best for now (have to filter out the blanks though otherwise the inverse metric (blank rows/not missed) dominates the visualization (as it'll be around 90% of the space with the drivers vying for the remaining 10%).

KieranAdair
7 - Meteor

Thank you for your replies Amelia and Brad!

 

I think the problem is that I'm trying to show percentage point movement for those drivers week to week, like this:

 

Page 1 - Overall Performance

 

DateWeek 1Week 2Week 3
Result10%12%8%

 

Page 2 - Performance Drivers

 

DateWeek 1Week 2Week 3
No Available Operators6%6%2%
After Hours Calls4%6%6%

 

With AII picking up on the pp movement between the drivers week on week (ie. No Available Operators changed by 4pp this week), instead of the total volumes, as the volume of calls may differ over time.

 

That said, I'm thinking this may not be an ideal use case at the moment - and that Brad's solution (to show a raw count using the Number of Record ID) with the reason breakdown may be the best I can do at present. I have to filter out the blank rows though otherwise they dominate the visual.

KieranAdair
7 - Meteor

A bit of a workaround, but after playing around with this a bit more I've had some luck with One Hot Encoding the drivers too:

 

Record IDLocationAnswered  YNN ReasonNumeratorDenominatorNo available operatorAfter Hours Call
aSydneyY 0100
bSydneyY 0100
cSydneyNNo available operators1110
dSydneyNNo available operators1110
eSydneyNAfter hours call1101
fMelbourneY 0100
gMelbourneY 0100
hMelbourneNAfter hours call1101

 

Can't use these on the same axis, but at least I can then use these to get movement changes for specific segment breakdowns (ie. % of After hours call has increased in Sydney etc).