Data Studio
5K members online now
5K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Weekly count of metric per user

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I'm trying to create a Data Studio report for counting some weekly data.

 

 

Our app is a fitness workout app, and I want to know the counts of "workouts per user per week".

 

Everything I try either doesn't display the results I want, or I get "System error" issues.

 

I have connected a BigQuery table of workout_logs that has a created_on Date property with values such as '2016-07-13 14:42:26'.

 

For a given week the data would show something like this:

 

1 workout: 1,000 users

2 workouts: 200 users

3 workouts: 30 users

5 workouts: 10 users

 

(zero users had 4 workouts, just for example)

 

How should I set this up?

 

It seemed like a pie chart or table might be good, but I couldn't get the Dimension correct. I tried using YEARWEEK(), and just setting the data type as ISO Week, and several other things.