COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Dashboards => Topic started by: anandcognos on 12 Jun 2023 02:07:16 PM

Title: Automatic addition of column in a crosstab if user selects in another widget.
Post by: anandcognos on 12 Jun 2023 02:07:16 PM
Hi,

I created one dashboard with a crosstab and trend graph. In the attached picture all_data.jpg we have a crosstab 'Profit and Loss' and Trend Graph 'Monthly Visits trend for Current AY'. FP dimension is added as a column in crosstab and as a x field in a trend graph.

My questions is -

Lets say if user selects 2022.08 in the trend graph as shown in the attached 2022.08_data.jpg, will it get automatically added in the crosstab as a column. I believe it can not and the only way to see it as a column in crosstab is to go in the filters of profit and loss crosstab and select it there. Let me know if my understanding is correct, also if there is anyway to automatically add 2022.08 (without selecting it from a filter of crosstab) as a column in crosstab by only selecting it from any other widget (trend graph in my case). I will appreciate your help.

Thanks and regards,
Anand
Title: Re: Automatic addition of column in a crosstab if user selects in another widget.
Post by: cognostechie on 12 Jun 2023 07:02:26 PM
Hi

Your attached .jpg is not visible and I don't think you can attach images here.

It is possible to connect the graph and the crosstab. Make sure both of them use the same query and then they will use the same data so when you say 'select 2022.08 from the graph', do you mean you have drill-downs? Are you using a dimensional package which is using a Cube or a DMR? If so, yes, drilling down on one should automatically filter the other.