Line chart of weekly accumulative unique values

[Daiwp]

Lets say I have a data table like below

id	uuid	date
1	1	2023/04/04
2	2	2023/04/05
3	1	2023/04/11
4	3	2023/04/12
5	4	2023/04/13
6	1	2023/04/18
7	2	2023/04/19
8	5	2023/04/20
9	5	2023/04/21

That means we have the following unique users

• 2 people in 1st week
• 3 people in 2nd week
• 3 people in 3rd week

But accumulatively we have

• 2 people in 1st week
• 4 people in 2nd week
• 5 people in 3rd week

So how can I make a line chart showing X-axis as a weekly dimension and Y-axis has 3 values: 2, 4, 5?

[mpazbernal95-16 · Accepted solution]

Hey @Daiwp 

What if you used a derived table to get a user’s first visit date in the month? This document has a great example that gets first order date.

Once you have that, you could join it to the current explore and query first_visit_date and count. Then you could do a running total either by using a table calculation or the running_total measure type.

[Daiwp]

Thank you @mpazbernal95-16  Let me try it.