How to show data of users don`t active in the last 30 days?

[Haidannx]

Hello everyone,

I have a problem like below:

I have a Fact table said which user active on my system, the date they active,...

and another Dimtable of total User of the system.

Now how can i know which user activate in the last 30 days? 60 days? 90 days?

Many thanks

[Ashish_Mathur]

Hi,

Share a simple dataset and show the expected result.

[Haidannx]

Fact table

User id	Date created	Tags
1	2020 - 02 - 05	add
2	2020 - 01 - 18	buy
3	2020 - 01 - 18	create
4	2019 - 01 - 31	add
5	2019 - 05 - 14	tag

Dim table

User ID	Name
1	A
2	BC
3	C
4	D
5	#
9	5

Now how can i know which User doesn`t active in the last 30 days ? (it supposed to be user id 3, 4, 5, 9)

[vivran22 · Accepted solution]

Hello@Haidannx 

Please find the sample solution file here

Regards,
Vivek

If it helps, please mark it as a solution

Kudos would be a cherry on the top 🙂

https://www.vivran.in/

[Haidannx]

It worked.

Many thanks.

[Haidannx]

Hi @vivran22 

Many thanks for your answer

Still i find out that those user doesn`t active at all since the day their account were created will not appear in fact table

how can i calculate those accounts too?