Forum Discussion

lhaokip's avatar
lhaokip
Regular Visitor
3 years ago

Need Help

Hello,

I have a data set with column name as Name , Team and In month P2G. I can get quartiles base on in_month_P@G in separate column or measures.

How do I find all the quartile (Q1,Q2,Q3,Q4) in single column?

How do I find who(name) belong to which quartile?

 

I want my visual as 

Name   TeamIn Month P@G  
Aman Saini    CTC80.12%Q1
Damris VashumCTC213.78%Q2
Cody Kellyilms-ort tada52.90%Q3

 

 

This is the Screenshot of my data