Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 6 Next »

If for some reason the trends aren't showing up. Its likely that the his tz (timezone) doesn't match the point tz. To fix this, follow the below steps.

Issue - Los Angeles != Indianapolis

Currently the points have tz set as Los Angeles, but his data is set to Indianapolis tz. 

Option 1: Setting all to Indianapolis

We want to set everything to Indianapolis tz. So go to the site and select the tz to be Indianapolis. Then click on the Sync Time zones For All Points. Doing this will match the points and his data. You should be good now.

Option 2: Setting all to Los Angeles

We want to set everything to Los Angeles tz. The user will need to match the point tz to the his tz. The user will follow Option 1 first to match the both his and point timezones. Once done doing Option 1, we'll need to rewrite the tz on the his data to Los Angeles. To do this, go to folio and run the query below for all points (if you have multiple sites with different tzs, we recommend using siteRef in the query).

Query: readAll(point).each x=> hisRewrite(x->id) (val, ts) => [ts.toTimeZone("Los_Angeles"), val]

Note: Change "Los_Angeles" part to what timezone you want it to be.

Then once changing the his tz to Los Angeles, go to the site and change the timezone to Los Angeles and sync it to all points. Thats it, everything should now be using Los Angeles tz.

Changing to new timezone

If for some reason the tz isn't what you want and you want to change it. The user would first change the his tz and then the point tz.

Step 1: 

We'll need to rewrite the tz on the his data to Los Angeles (or whatever timezone you want). To do this, go to folio and run the query below for all points (if you have multiple sites with different tzs, we recommend using siteRef in the query).

Query: readAll(point).each x=> hisRewrite(x->id) (val, ts) => [ts.toTimeZone("Los_Angeles"), val]

Note: Change "Los_Angeles" part to what timezone you want it to be.

Step 2: Go to the site and change the timezone to Los Angeles and Sync it to all points. Thats it.

Finding the his tz

Here is how to find the his tz on a point.

First, copy the id of one point that has the issue.

Then run a hisRead query for that point to get the below error: read(id==@1ffcb9fa-02e6aeba).hisRead(today)

That will let you know what which timezone its using. In this case its Indianapolis.


  • No labels