Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Provide some sample data to work.
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.
Or for a calculated dimension:
=Aggr(Only({<[last interaction date] = {"<=$(=AddMonths(Today(1), -6))"}>} ClientName), ClientName)