I want to use the function distinctCountOver - counting distinct IDs over a month (and adding this filed to a table that is not aggregated by month).
When I use count_over function I get results however when I use distinctCountOver I get an error.
countOver(ID,[extract(‘MM’,Timestamp)],PRE_AGG) - works
distinctCountOver(ID,[extract(‘MM’,Timestamp)],PRE_AGG) - error: Please correct the
distinctCountOver to use PRE_AGG or PRE_FILTER levels and partiton only by column references.
I am not sure what I am doing wrong and how to fix it.
What am I missing?