Help with set Analysis

[Anonymous]

Need to show last   Months months data for current year and previous year present in the data. We have full name as the dimension , for each full name we have to count distinct of Document ID's ( DOCID). When user picks 2017 as year the Document count for 6 months should show from maximum of year month to 6 months. The tricky problem is for some Full names the data is not there for some months still it has to show the maximum year month.

let me know if you have any questions.

[sunny_talwar]

Max 6 months based on the max date available for each FULL_NAME? What is the expected output for the above sample you have provided when 2017 is selected in YEAR?

[Anonymous]

Sending QVW file for explanation

[Anonymous]

See the Attached app

[sunny_talwar · Accepted solution]

May be try to ignore selection in your set analysis

=count({<YearMonth={">$(=MAX({<YearMonth, FULL_NAME>}YearMonth)-6)<$(=MAX({<YearMonth, FULL_NAME>}YearMonth)+1)"}>} distinct DOCID)