I was downloading some interactive trends this week from groov and with the help of product support noticed that the trend time stamps are displayed in UTC Time Zone.
With manipulating the timestamp in Microsoft Excel we could get it to my time zone of UTC+10 with the following formula:
My question is though can there be a setting added into groov that nominates the time zone you are in so you don’t have to worry about the different formula?
I believe that the software engineers have looked at the trend time stamps and kicked around some ideas, but keep coming back to the UTC/UNIX timestamp.
The reason for this is that we have a lot of customers using groov across many different time zones. In other words, think of a nation wide company feeding PAC data back to a central groov. What time zone do you put on each trend?
The other challenge is daylight savings. Having the trends roll forward and back for each location just complicates things unnecessarily.
By having the same time stamp the same across all locations, we allow each customer full flexibility to adjust the time stamp to suit their company needs.
Granted, the groov manual does not really go into detail on how to do this and we will be looking at addressing that shortfall.