topic Re: Colors greyed out after selection in App Development

Colors greyed out after selection

deniscamh — Wed, 04 Apr 2018 22:02:17 GMT

Hi all,

I created a bar chart with the years and categories as dimensions:

My expression is: count({<Total_Period = {'Past Actions'},Year = {">= $(=Year(AddYears(Max([Action Date]),-5)))"}>} distinct [Action Import ID])

When I make a Year selection the colors for not selected years become grey but the data still showing:

What should I do to prevent colors become grey?

Thank

CarlosAMonroy — Wed, 04 Apr 2018 22:06:32 GMT

Hi Denis,

Maybe just add the year to the set analysis as a exclude selection field. Something like:

count({<Year=, Total_Period = {'Past Actions'},Year = {">= $(=Year(AddYears(Max([Action Date]),-5)))"}>} distinct [Action Import ID])

Hope that helps,

Carlos M

deniscamh — Wed, 04 Apr 2018 22:09:54 GMT

Thanks Carlos,

I already tried it.

Does not work, same result.

Thanks

d44973694 — Fri, 20 Dec 2019 14:51:56 GMT

Did you find a solution to this?