Question

Date filter comparisions

  • 4 August 2017
  • 1 reply
  • 309 views

Is there a way filter data to compare today’s current data (based off beginning of day to current hour) to the same time frame yesterday (beginning of day to current hour)?


Similarly, is there a way to filter data to compare the past 7 days to the previous 7 days no matter what day of week it is?


1 reply

Userlevel 2

Hi Tracy!


I’ve linked a couple options worth exploring below:





  • This option essentially uses two filtered measures that respond to inputted UI filter values





  • This option uses a matches advanced filter expression


If you have further questions, feel free to hop on chat or visit us at help.looker.com

Reply