Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am havingaissue with Sorting order for Bar chart.
1st Dimension: Country -> State-> City (Drill Down)
2nd Dimension: Language Known
Measure: Count of Population
Wheniam giving sorting byexpression:Count(population)
The data in the graphis not sortingproperly.
Can someone help me howto makeit work.Please find the attached app forrefrence.
Note: 2nd dimension is having nulls.
Thanks,
Santosh Aravind
Hi
You have two dimensions right, Change to custom mode and give sorting based on your dimension.
Post sample data or app
Hi,
I changed into custom mode and applied the expression. However, the second dimension is having nulls. I am thinking that might be the reason where i am not able to sort properly.
Thanks,
Santosh Aravind
Might be....uncheck " Show null values " and try once
remove the nulls and check it. how do you want to sort the chart. post the app
Hi All,
I attached the app. Please take a look at the app and let me know where i need to do the changes.
Thanks,
Santosh Aravind
If i add show nulls the data is sorting in the exact descending but i dont want to show nulls. When i uncheck them the sorting is not happening properly.
do u want like this ?
if yes in drill down disable sort alphabetically
How you want to display?
By Total Population?