Show data in quicksight filtering specific agency timezone

Question & Answer
1

I have a agency info dataset containing agency_id, agency_timezone and other dataset containing created_at,closed_at dates.I want to edit by pre existing dashboard showing data in the specific timezone of the agencies.My dashboards are embeded using agency_id in the application.Can you suggest best method to do in minimal time

2

@jvolpert

few approaches

  1. Pre-calculate agency timezone-specific datetimes (before it comes to QS).
  2. Use calculated field and create agency_datetime_fields using addDateTime
  3. If your dataset is getting data through SQL query then you can use that with parameter, where the user selects timezone, And then use that parameter value in query (not cache data in spice), And do that in the query.
3

Hi @jvolpert and @neelay,

We are now supporting custom time zone as an out-of-box feature for QS (QuickSight launches Custom Time Zone) . Please try and let us know if any feedbacks. Thanks!

1 Like