Forum Discussion

Sri_phani's avatar
Sri_phani
Icon for Helper III rankHelper III
2 years ago

Adding the Quartile summary

Hi,    Can someone help me summarize the Quartiles that I created using a Measure.  I have data that has the Customer Resolve Survey score and I created a Quartile using this measure:    Res% Q...
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Sri_phani ,

I think you can create a new table to show the number of agents and the max and min scores for each quartile.

Quartile Summary =
SUMMARIZE (
    '1_Core Raw data',
    [Res% Quartile],
    "Number of Agents", COUNT ( '1_Core Raw data'[agent_email] ),
    "Max Score", MAX ( '1_Core Raw data'[Resolve] ),
    "Min Score", MIN ( '1_Core Raw data'[Resolve] )
)

You can also add slicer to filter the data.

 

 

 

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.