COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Dashboards => Topic started by: oscarca on 21 Feb 2019 06:40:44 AM

Title: Dashboard ratio calculation
Post by: oscarca on 21 Feb 2019 06:40:44 AM
Hello Cognoise

I am building a dashboard that consists of a stacked bar chart based on Gender for every country, for example 200 woman and 600 men in Sweden. What I am interested to see is on the chart, is the ratio rather than the numbers i.e 75 % men and 25 % women where the Y-axis range from 0 % to 100 %. The stacked bar chart is using "Gender" for color, "Countries" for bars and "Gender Count" for length.

Any ideas how to accomplish this ?

Title: Re: Dashboard ratio calculation
Post by: oscarca on 25 Feb 2019 05:37:02 AM
*******solved*********