Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am supposed to display charts with varied dimensions based on the selection of the 'Year'.
I have enabled two conditional dimensions and displaying two charts based on the selection as below,
1. When User selects any Year other than current year, (Condition : "=if(GetFieldSelections(Year)<>max({1}Year),1,0)").
2. When User selects current Year,(Condition: "=if(GetFieldSelections(Year)=max({1}Year),1,0)").
But when user selecting nothing I want the Chart to be displayed with the 2nd condition. Any quick response would be a great help to me.
Regards,
SV
Hi,
Maybe you can use GetSelectedCount(Year) = 0
Cheers
1 for no selection or max Year
else 0
=if(max(Year)=max({1}Year),1,0)