Count Distinct over Time period

Hi all,

I would like to create a "count distinct" over a 30 days window.

I.e.:

- We have the product ids per day, say 200-300

- We have this data for the last 12 month

- I would like to know the total number of different products (count distinct) for every 30 day period from today back to 12 months ago.

Could you please support? Thanks

Datasets

Help

Accepted answers

All comments

Hello @DanS_AMS ,

do you want it on 30 day periods or based on every month? Also could you please create a mock data to show how it comes?

Regards

Here's a way of doing it for rolling 30 day groups based on today's date:

These date ranges will update every day, so this might not be the solution you're after...

countdistinct.yxmd

Yes, it would be a 30 days period, i.e. today would be the range 29-10-2021 to 29-11-2021, yesterday would be the range 28-10-2021 to 28-1-2021 and so on.

Let me work on a simplified mock and I will share it here.

Thanks

Hi @OllieClarke,

thanks for your response. Indeed, I would need it to be static, so for every date, it should show the distinct products of the respective last 30 days.

Quick Links

Tags

This months top contributors

AkimasaKajitani 388

Hollingsworth 335