ignoring selections in set analysis in text box

[hathwarjaya]

Hello All,

I am stuck in one thing and not been able to solve it.

I need to ignore selections in the following expression where i calculation the data for last 7 days but even after putting 1 in the set it does not work.The set analysis expression is in the text box

=count({1<CHANNEL={sales},Date2={">=$(=Date(max(Date2)-7))"}>}ticket_ID)

Please help

Thanks & Regards,

Jaya

[tresesco]

Selection ignorance has to be there in all aggregation functions. You haven't used it in max(). Try like:

=count({1<CHANNEL={sales},Date2={">=$(=Date(max({1}Date2)-7))"}>}ticket_ID)