google-bigquerylooker-studiolooker

How do I add the current Week number in Looker Studio on screen

I think what I probably need is a calculated field with something like this in the formula:

WEEK(CURRENT_DATE())

But I can't figure out how to include that in somekind of Scorecard or some other visual element where I can display a TEXT (String) bound to live data like the current datetime on my Looker Studio page.

Solution

  • Simple

    1. Add a score card to the page
    2. Add date as a metric to the scorecard
    3. Click on the edit button on the date metric in the score card
    4. Change the datatype to ISO week
    5. Change the aggregation to Max

    This will provide you with a week number for the latest week in the data