We are encountering problems with quater count of records.
Uniqueness is accurate for month; not if you aggregate for quarter or year; for example, user is active in Jan, Feb and Mar – The system would accurately show 1 active user for each of these months, but would show 3 active users for the 1st quarter (doesn’t recognize that it’s the same unique user).
We want to count the active user only once for that quarter.
Is the way to count that active users only once for that quarter instead three times. Please help and your input is appreciated.