-
1. Re: How to display the Ranking when we have Dual-axis chart and we want ranking based on a single measure?
Jyothisree Rayagiri Feb 23, 2018 3:06 AM (in response to Bhagyashri Patil)Use a fixed calculation
{fixed [Country],[Sport]:([Total Medals])}
and use that for sorting. Irrespective the count of types of medals, it will sort only on total count
-
2. Re: How to display the Ranking when we have Dual-axis chart and we want ranking based on a single measure?
Bhagyashri Patil Feb 23, 2018 3:51 AM (in response to Jyothisree Rayagiri)Thanks for response.
But, I am not asking about sorting scenario. I need a "Rank" dimension giving me ranking based just on the "Total Medals" of Countries.
Could you kindly go through the workbok, if having free time.
-
3. Re: How to display the Ranking when we have Dual-axis chart and we want ranking based on a single measure?
Jyothisree Rayagiri Feb 23, 2018 4:22 AM (in response to Bhagyashri Patil)Workbook attached.
You can just use the Rank calculation -(TotalMedalsRanked in the workbook)
When you use it in the view, make sure to set the calculation to be along country,countryname and iso
-
Olympics.twbx 720.0 KB
-
-
4. Re: How to display the Ranking when we have Dual-axis chart and we want ranking based on a single measure?
Bhagyashri Patil Feb 23, 2018 4:54 AM (in response to Jyothisree Rayagiri)Hi Jyothishree,
I absolutely got the point which you are trying to convey. But, I am not getting the desired outcome in my sheet.
Kindly refer the issue in the attached screenshot, after using the Rank calculation. (TotalMedalsRanked in the workbook)
The whole chart gets bifurcated into two parts, when I try to bring the Rank calculation in view.
Please help.
-
5. Re: How to display the Ranking when we have Dual-axis chart and we want ranking based on a single measure?
Jyothisree Rayagiri Feb 23, 2018 4:56 AM (in response to Bhagyashri Patil)You want to show the rank on the view ?
-
6. Re: How to display the Ranking when we have Dual-axis chart and we want ranking based on a single measure?
Bhagyashri Patil Feb 23, 2018 5:05 AM (in response to Jyothisree Rayagiri)Yes, on the view itself. I dont want sorting, I just want the Ranking in my current visualization view.
-
7. Re: How to display the Ranking when we have Dual-axis chart and we want ranking based on a single measure?
Jyothisree Rayagiri Feb 23, 2018 5:51 AM (in response to Bhagyashri Patil)We cannot take it as a dimension since you have the medal split for colours
Drop it as a label next to the measure you have for flags and set align to right.
workbook attached
-
Olympics.twbx 737.8 KB
-
-
8. Re: How to display the Ranking when we have Dual-axis chart and we want ranking based on a single measure?
Bhagyashri Patil Feb 25, 2018 10:46 PM (in response to Jyothisree Rayagiri)Okay. sure. I'll try it. Thanks Jyothisree.