Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can i sort this chart?
from full blue to minimum blue color. that means highest yes percentage to lowest
HI
Sort tab, use expression
and give descending order.
in expression tab, give the expression first expression..
ex:
1.sum(sales) display as blue color
2.sum(discount) display as red color..
Give sum(sales) in expression in sort tab..
Hope it helps
or
pls share sample file..
I tried this but it didnt work. Please note we have 2 dimensions, "Locations" and "Recommend hospital" so in the sort we select the dimension and check the sorting technique we want.
Any other ideas???
IN expression under sort tab, try using COUNT({<Recommend Hospital={'Yes'} >} Recommend Hospital) and descending order