Line chart of weekly accumulative unique values

Looker Q&A Looker
, ,
1

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?

2

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.

3

Thank you @mpazbernal95-16 Let me try it.