I have built a report based on data in Redshift.
My data in Redshift is in the EST time zone, while the Date parameter (today) is in UTC.
Because of this, data for today is not displayed after EST 8:00 PM .
Can I convert the parameter to EST? Perhaps the only solution will be converting the data from Redshift to UTC?
Yes, you can convert time zone either for QS or Redshift.
But as I mentioned above, I am using different time zones. This causes an error when I change the time zone settings in the dashboard (Menu Sheets => Layout Settings)
I managed to fix the issue myself using the instructions.
I had to convert the data in the database to UTC and then switch my dashboard to EST.
2 Likes