How to display data by week on a chart in Looker Studio?

[Arisride]

Hello,

I have a set of data regarding users, and each of them have a creation date. I want to display the number of users created per week on a graph, so I basically display the record count related to creationDate. However, when I use the arrows on the graph to change the level of granularity, it goes from "per day" to "per months" directly.

Is there a way for me to display the Record Count by week?

Thanks

[Former Community Member]

I am not sure what you mean by arrows on the graph. However, if your timestamp is a dimension group w/ timeframe of week specified in lookml you should be able to do this (pseudocode):

ts_week, count_distinct(users)

if you want a nicer date  you could do min(date) for each week to get date of first day of the week.

PS Apologies did not notice it was a looker studio, not looker question. This won't work in studio.

[Mehdi_Oudjida · Accepted solution]

@Arisride 

Inside Looker Studio, the drill down on date field allows you to configure the granularity you wish in separate fields editing the series chart. In view mode (the arrows in the header), you can just access to the drill down configured by the report editors.

here what it looks like on the configuration side.

I hope it helps.

Mehdi