Set analysis date issue

[mario-sarkis]

hey all i have a field Of this form "last interaction date"(6/1/2016,....) my question is:

the data set contain list of client ids with their last interaction date:

i need to show a list of clients that are not contact the last six month

how can i write in the set analysis?

Hope you can help.

thanks you

[MK_QSL]

Provide some sample data to work.

[jonathandienst]

Something like:

Concat({<[last interaction date] = {"<=$(=AddMonths(Today(1), -6))"}>} distinct ClientName, ', ')

to display in a list box. Replace ClientName with the correct field name.

[jonathandienst]

Or for a calculated dimension:

=Aggr(Only({<[last interaction date] = {"<=$(=AddMonths(Today(1), -6))"}>} ClientName), ClientName)