This message was deleted.

Hi @Avishek Gurung, I am just looking at your example. Are you planning to use rollup during ingestion? Without rollup, you could use a filtered metric, I believe. I’ll try it out now.

Yes @Hellmar Becker. We have huge data and we want to use rollup to reduce data size and faster query execution

How about a count of purchases within the time period? Repeat users are the ones that either appear in both A and B or have a count of purchases greater than 1 in the selected period.