I have an Item i can't solve. I need to count distinct email addresses when they have an action type = to "Success"
They are from a Start date to plus 3 days from the start date.
In SQL along the lines of-
select count(distinct case when status = 'Success' and datediff(day,CreatedDate,StartDate)<=3 then email end)
I think I need set Anlysis syntax but I cant get it right.
this is in Qlik Sense
Thanks for any help provided,