By Selecting one chart the other should not get changed

[kunkumnaveen]

Hello All,

I got two pie charts

First Chart

Dimension:Management

Expression:

Count({<[CRITERIA]={'MANAGEMENT'},Funding=>}distinct Supplier)

Second Chart

Dimension:Funding

Expression:

Count({<[CRITERIA]={'FUNDING'},Management=>}distinct Supplier)

My requirement is either chart Dimension is selected the other chart should remain unchanged

but it not happening in my case even though i disable the selection in set analysis

I tried by using 1 in the set analysis of both the chart as below

Count({1<[CRITERIA]={'MANAGEMENT'},Funding=>}distinct Supplier)

Count({1<[CRITERIA]={'FUNDING'},Management=>}distinct Supplier)

but if i use 1 in the set analysis, even the selected chart remains unchanged,which is wrong ,

My requirement is selected chart should change the rest should remain unchanged

Thanks

[sunny_talwar · Accepted solution]

I see that your filter selection is showing =Management, instead of just Management as a field... is this a calculated dimension or something?

[kunkumnaveen]

I Have done this at backend

[ SCORES]:

load *,

if(SRMM_Criteria_Color='RED-MANAGEMENT',' ',if(SRMM_Criteria_Color='GREEN-MANAGEMENT','  ')) as Management,

[sunny_talwar]

and are you using Management as a dimension? Can you make sure to remove the equal sign from the chart dimension?

[kunkumnaveen]

I think ,the issue is because of that = sign

[sunny_talwar]

Yup, I think so too