Is there any way to set a data range to capture information from just weekdays?
We have a daily meeting to verify last working day performance and Monday is always an issue since the data range on the report is set-up as “yesterday”. Since Sunday is not a working day for us we need to manually adjust the report every Monday to reflect the information from last Friday.
Thank you!
Well that depends on how your data source is structured.
If you have connected table via BigQuery and aggregate your numbers daily you can just add additional column with a boolean type of field: Week Day Yes/No and create a parametr filtering based on this field.
I am thhinking that this logic should help you achieve this butt never tested it:(
Anothehr way is to create 5 same pages eaccch for different days of week and use navigation to toglle between days but I am not seeing muchh of a value here hence there always be some kind of manual togglinng included.
Hello! It’s not possible to do this with the current settings for date range controls.
That being said, if you would like to do this from a Looker Studio control please file a feature request for our team. Here are directions on how to do so!
https://support.google.com/looker-studio/answer/7340016?hl=en
Thanks!
Hi @ArkadyZagdan your solution didn’t work but gave an idea… I have created an additional column with a “Fake Friday” date which is Friday plus 2 days (Sunday)… then I have created another column to verify today’s workday… If is Monday it will push yesterday’s data from the Fake Friday (Sunday) if not it will get yesterday’s data from the actual date.
Thanks!