Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Thanks Carlos,
I already tried it.
Does not work, same result.
Thanks
Did you find a solution to this?