Scheduled Delivery Report Has Different Totals In The Dashboard Reports Due To Timezone Difference In The Queries Timezone Conversion

News Knowledge Base
1

Why does the Scheduled Delivery Report show different totals than the Dashboard report?

The dashboard issues queries that have local time zone conversion while the schedule report queries currently do not have that conversion so the two queries actually scan data in different time periods, causing data discrepancies.

Root Cause: This happens when Looker timezone is set to a different timezone than the local user.

Resolution:

  • Edit the dashboard, for each tile in the dashboard
  • Change the timezone of the tile to ‘The Viewer’s Time Zone'
  • Now the schedule should have the correct timezone conversion and thus no longer having the data discrepancy.