set analysis with exclusion

[#1]

Hi Guys,

I would like to create an expression of sum of  "ImpressionAction" in the  dates between the variables "vYeasterday" and "v3days" (this works fine on it own) AND excluding 2 partners id: 221, 2019.

Can you tell me the correct syntax?

sum({1<DateOnly= {"<=$(=vYesterday) >=$(=v3days)"}, partner_id-={221,1019}>} ImpressionAction)

Again, without exclusion, when selection only the dates between the variables it works fine.

Thank you!

[aveeeeeee7en · Accepted solution]

Hi Elula

Try any 1 of the Expression as per your requirement:

1) sum({1<DateOnly= {"<=$(=vYesterday) >=$(=v3days)"}, partner_id={'*'}-{'221','1019'}>} ImpressionAction)

2) Sum({<DateOnly= {">=$(=vYesterday)<=$(=v3days)"}, partner_id={'*'}-{'221','1019'} >} ImpressionAction)

Regards

Aviral Nag

[#3]

Hi Aviral,

Thank you, your suggestion worked!