Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have ONE chart with variable dimension and corresponding counts. Based on a variable this chart will show counts for (Sex) or (Insurance)
If variable 1 is selected, the chart will be as follows: Note: (Sorting is based on ascending order of Sex column)
Sex Count
Female 12
Male 24
Unknown 2
Total 38
If variable 2 is selected, the chart will be as follows: Note: (Sorting is based on Descending order of Count)
Insurance Count
Insurance 2 20
Insurance 1 11
Insurance 3 7
Total 38
Please help me accomplish this using expression
Use these 2 expressions for each dimensions in Sorting Tab (sort by expression)
For S**: aggr(Yourexpression, S**)
For Insurance: aggr(Yourexpression, Insurance)
And then adjust the expression sorting to Ascending or Descending as per your view.
Dimension itself is changing based on selection of a variable?
Yes
Would you be able to share a sample where you are trying this?