Does your data come in in a timezone that's not your own? Use the time shifting transform to shift the timezone of your data.
To do this, click on the +Add Transform button, then select Time Shifting near the bottom or the list.
The window that pulls up, will show you three fields: Column, Operator, and Offset.
In the Column field, choose the column that includes the time you want to edit.
The Operator field gives you two options: Add or Subtract. Based on your timezone (in relation to UTC), you will either add or subtract hours.
The Offset field will give you a list of hours to either add or subtract. Select how many hours your are offset from UTC time.
How to identify the time zone of a data source
We are actively working to improve this, but the short answer is it depends on the data source.
The first thing you should do is google the data sources API. For example if I was trying to find the timezone of my Shopify data, I would google "what timezone is shopify api in?"
Adding the term API will help differentiate from the results of people using the native application. I found this article that explains that the data comes back based on your stores timezone.
If you are having trouble you can also reach out to our support team.
If a timezone is widely known for a data source, we will include that information in the Data Source help article as well.