Hi team,
I am sourcing data from Bigquery table and building a dashboard in looker studio. I have Year, Month, Week, date and Sales fields in my source table and want to create 3 scorecards - MTD: Month to Date sales based on the Week selected
QTD: Quarter to Date sales based on the week selected
LastYear: Last year same week sales
Is it possible to create these scorecards in Looker directly?
If not, may I know the workaround, thanks.
Regards,
Onkar