Sql local time for druid

We use superset for supporting druid and dashboard. As we have a lot of datasources which can be used by some people from different countries, now we would get data mapping local time not UTC time, the time will be 7hr or 8hrs earlier than local time zones. How should we do? I used below:

TIME_SHIFT(<timestamp_expr>, , , [])

**for example, for Indonesia, I used **** **TIME_SHIFT(__time, ‘P1D’, 0, ‘-07:00’), but it does’t work.

anyone can help me ,thank you