I have a dataset and for each row I have an email id and a corresponding event (delivered, open, click etc).
So, I can have multiple rows with the same email id, but different events.
I’m creating some analysis on email ids that have only have an open and click event. So I need to create a filter for a chart which shows only this type of data.
I have tried the below, but it’s not working on the chart as I thought.
CategoryNum = ifelse(event = ‘click’, 2, event = ‘open’, 1, NULL)
OpenClick = distinctCountOver(CategoryNum, [EmailID], PRE_FILTER)
Then filter where openclick = 2
One of the charts is Month Email Sent on x axis, and distinctcount of Email IDs on Y axis.