When you create a weekly report in Looker Studio you can use the ISO Week field type. But it is super long and often you can't see the full week's name.
I started to use formulas to extract the first day of the week and make the dashboard nicer for the user.
In the video I work in the Looker Studio file - lookerstudio.g...
The full formula I use:
Week in Looker Studio = EXTRACT(Date FROM DATETIME_TRUNC(Date, WEEK))
----------------
Video prepared by Gaille Reports - gaillereports....
Marketing dashboards template store - gaillereports....
Looker Studio Online Course - gaillereports....
Blog about Looker Studio and Google Sheets - gaillereports....
Our Telegram group - t.me/gaillerep...
12 сен 2024