Quicksight - Best way to shift time by timezone and assign to shift?

0

I have a timestream table that has timestamps in GMT. I need to do two things with this time:

  1. Shift it to my timezone.
  2. Determine what shift the timestamp happened in.

It looks like there is an Excel like ifelse() statement. I have 22 different shifts to examine for. Those cascading ifelse() will get quite complicated. Is there a better way of doing this?

flycast
asked 2 years ago52 views
No Answers

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions