Forum Discussion
Graph and visualization help
Hey ,
So here's what i did, i grouped the the table using edit query, and the group by transformation as shown below.
Now , on the data modelling section , created two column as below
Rank= IF([AccountSegment]="Core",RANKX('Account Grouped',[FYTD]))
and
categorize = SWITCH(TRUE(),[RANK]>25, "Remainder",
[RANK]>10, "Next 15 Core",
[RANK]>0, "Top 10 Core",
"G360")Now use this categorize column to create the visual.
Hope this servers your need.
Regards.
Hi ,
The top visual can be achived using the waaterfall chart , give it a shot, it should work.
For the below information , you would have to place tables for the respective information .
Regards.
thanks for this
But it doesn't looks like it works
How do i categorise G360, Top 10 core , Next 15 core, Remainder?
https://www.dropbox.com/s/1n3gtyqxb8wjncn/data.xlsx?dl=0
Can you please try and share? how you think this can be achieved?
sample file attached in the link.
how are you expecting the values of G360, top 10 core, top15 core ?
is it based on the [account] column? or based on [TER_FYTD_USD]?
Its based on account and [TER_FYTD_USD]
basically it means
G360 accounts
Top 10 core accounts based on the [TER_FYTD_USD]
Next 15 core accounts based on [TER_FYTD_USD]
Remainder accounts based on [TER_FYTD_USD]