Mark redundancy in chart

[kinjal1645]

Hi All,

I want to mark configs (combination of parameter1 to parameter5) that are redundant within team and globally.

I am able to mark configs that are redundant within a team:

But I didn't find right formula to mark configs that are redundant globally

Expected (for same selections as above i.e. team A is selected):

Kindly help!

Thanks,

Kinjal

[sunny_talwar · Accepted solution]

Try this

If(count( {<Team>}distinct total

<

//Team,

parameter1,

parameter2,

parameter3,

parameter4,

parameter5> IDS) > 1 and count(distinct total

<Team,

parameter1,

parameter2,

parameter3,

parameter4,

parameter5> IDS)<=1 and Team = Team,'X')

[kinjal1645]

Thanks Sunny!

It is working

Can you explain what you did here?

[sunny_talwar]

Two things

1) Ignored selection in Team for your existing condition because if you don't then the condition will honor your current selection of Team and will count within Team A only. Whereas you wanted to count across all teams

2) Since you only need the X on the second row... to remove the Xs from 3rd and 4th row... I gave the opposite of the 1st condition so that it doesn't satisfy and doesn't place X for where it already have

3) Left Team = Team by mistake... I think it should still work without that condition