I have a table that includes email data where there can be multiple lines per email (sent, opened, click etc). Users should only receive one email per day max so I am trying to set up a kpi report that will send an alert if the total emails sent yesterday exceeds the total number of unique email addresses in the data. I am trying to do this using distinctCountOver but the results are confusing.
I created a calculation to work out total email addresses in the data
distinctCountOver(username,[customerCode],PRE_FILTER) and was going to compare this to the distinct count of emails filtered by yesterday. but Iget the following result (this is before I even put a filter on and I would expect these numbers to be the same
Any help is appreciated, thanks