Hi folks,
I have this chart that shows the evolution (by month) of evaluation (good, regular, bad) of projects. I have 32 projects but I only want to show values for a specific month if all the 32 projects have the evaluation.
Ex:
October - 32 projects evaluated
November - 32 projects evaluated
December - 10 projects evaluated
In my chart will be shown only October and November.
I tried using some aggregation in the Date dimension like this below, but didn't work.
=if(aggr(count(dat_evaluation_project),month_evaluation_project)=32 , date(dat_evaluation_project,'MMM/YY'))
Any ideas?
Thanks in advance.
