COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: yogeswari on 05 Sep 2017 07:23:46 AM

Title: Display chart based on country selection in the map
Post by: yogeswari on 05 Sep 2017 07:23:46 AM
Hi,

I want to display chart based on the country selection in the map.  For this I tried to achieve by putting Country in the X axis and Quantity in the Y-axis.  But I want to display Product Line for country in X axis and Quantity in the Y axis. 

I am attaching the document for references.

Please suggest me.

Thanks.
Title: Re: Display chart based on country selection in the map
Post by: MFGF on 05 Sep 2017 11:17:38 AM
Quote from: yogeswari on 05 Sep 2017 07:23:46 AM
Hi,

I want to display chart based on the country selection in the map.  For this I tried to achieve by putting Country in the X axis and Quantity in the Y-axis.  But I want to display Product Line for country in X axis and Quantity in the Y axis. 

I am attaching the document for references.

Please suggest me.

Thanks.

Hi,

Is this still an active report? If so, you would have your visualization (note - use a visualization not a chart) displaying Product Line in the Categories, and you would put your Country item into the Extra Categories area. You would then set up a connection between your map and the visualization, where the variable set by the map filters the visualization (use the Filter option rather than the Select option).

Cheers!

MF.
Title: Re: Display chart based on country selection in the map
Post by: yogeswari on 06 Sep 2017 05:54:50 AM
Yes, am using active report only. It is working fine.

Thank you very much for your inputs.