I have some sample data as per below
https://docs.google.com/spreadsheets/d/1X4lJK1M7zJpVNE8_aRBP5S5xq4nqy8VCs_E1Fbv3QDo/edit?usp=sharing
Each row in the table fdata has the following columns. [Name], [AHT], [Agent Group], [Date]
I have another dynamic date table that contains all dates between the earliest and latest dates in fdata called dimDate. And a relationship between the date columns in both tables is established . This table also stores month numbers, day numbers, months, days, quarters , years etc
I am trying to make a pivot table that shows how an agents AHT (average handle time) is tracking compared to the rest of the agents in the same agent group, for a date range selected by slicers
THe row filters on the pivot table are [Agent Group] then [Call Driver with Code] (which highlights specific enquiry types) . The values are the average of the AHT. Which works fine, filters by date and agent and skill group.
I then created a measure called "Skill Group AHT".
I'd like to be able to add Name and Date slicers for this Pivot Table. When I add the Name slicer, the data seems to filter correctly populating the agents AHT for [AHT] and the entire agent groups AHT for [Skill Group AHT]
However none of the date slicers seem to filter the data. They only filter the basic [AHT] function and not the [Skill Group AHT] one
Can anyone highlight what I've done incorrectly here, I'm at a loss
https://docs.google.com/spreadsheets/d/1X4lJK1M7zJpVNE8_aRBP5S5xq4nqy8VCs_E1Fbv3QDo/edit?usp=sharing
Each row in the table fdata has the following columns. [Name], [AHT], [Agent Group], [Date]
I have another dynamic date table that contains all dates between the earliest and latest dates in fdata called dimDate. And a relationship between the date columns in both tables is established . This table also stores month numbers, day numbers, months, days, quarters , years etc
I am trying to make a pivot table that shows how an agents AHT (average handle time) is tracking compared to the rest of the agents in the same agent group, for a date range selected by slicers
THe row filters on the pivot table are [Agent Group] then [Call Driver with Code] (which highlights specific enquiry types) . The values are the average of the AHT. Which works fine, filters by date and agent and skill group.
I then created a measure called "Skill Group AHT".
Code:
Skill Group AHT:=CALCULATE(AVERAGE(fdata[AHT]),ALLEXCEPT(fdata,fdata[Agent Group],fdata[Call Driver With Code],fdata[Date]),ALLEXCEPT(dimDate,dimDate[Date]))I'd like to be able to add Name and Date slicers for this Pivot Table. When I add the Name slicer, the data seems to filter correctly populating the agents AHT for [AHT] and the entire agent groups AHT for [Skill Group AHT]
However none of the date slicers seem to filter the data. They only filter the basic [AHT] function and not the [Skill Group AHT] one
Can anyone highlight what I've done incorrectly here, I'm at a loss
