Show dimension values in a chart based a condition

[rubenmarin]

Hi, a llitle changes with aggr, and to assure only 1 date are retrieved per month:

=aggr(if(count(dat_evaluation_project)=32, date(max(dat_evaluation_project),'MMM/YY')),month_evaluation_project)

Hope this helps

[#2]

Sorry, I branched it accidentally.

Unfortunately it didn't work. Here is a QVW with the chart I want to do.

Project 1 and 2 have the full evaluation for Jan-Mar and Project 3 has only evaluation for Jan and Feb. I'd like my chart shows only the dimensions Jan and Feb.

Thanks again.

Ruben Marin wrote:

Hi, a llitle changes with aggr, and to assure only 1 date are retrieved per month:

=aggr(if(count(dat_evaluation_project)=32, date(max(dat_evaluation_project),'MMM/YY')),month_evaluation_project)

Hope this helps

[rubenmarin]

Hi Gustavo, check attachment, I added a month field and a variable to assing max evaluations