Adjust graph to reflect the use of the Time Zone Offset

Started by Praxis

Adjust graph to reflect the use of the Time Zone Offset   28 May 2014, 12:25

Hi Andrew,

I've started using the "Time Zone Offset (mins)" with a value of 240 (4 hours) to represent the difference between UTC (Universal Time Clock) used by my ISP and local time EDST (Easter Daylight Savings Time) on my PC.

This is working well with the Usage Report, at 20:00 it begins to report the Date as the "next day" and the traffic for that "day".

However that the graph doesn't reflect the new Date and Data once local time has gone past 20:00 local time, it doesn't change until local time has gone past midnight. Then it reports the correct Date, and correctly includes Data starting at 20:00 the "previous day".

I took 3 screenshots, seconds apart at around 21:16, which show the graph still reporting the date as May 27 and the usage only up to 20:00 during the last 4 hours of the 27th, while the usage report is correctly showing the date of May 28 has begun and includes data between 20:00 and 00:00 of the 27th as belonging to May 28.

If it's not too much trouble, could you force the graph to show the Date & Data for the most recent "Day" row in the database?

Thanks,

J
Attachments:
open | download – NW 01 per day.png (41.8 KB)
open | download – NW 02 per hour.png (47.6 KB)
open | download – NW 03 graph.png (9.3 KB)
SoftPerfect Support forum - Andrew avatar image

Re: Adjust graph to reflect the use of the Time Zone Offset   28 May 2014, 13:18

Hi Praxis,

Is my understanding correct that both the first and the second screen shots are alright (per day and per hour reports are correct), while the issue is only seen on the real-time graph on the 3rd screen shot?

Andrew

Re: Adjust graph to reflect the use of the Time Zone Offset   28 May 2014, 21:38

Yes, that's right Andrew.

I'd like the top totals of the most recent day on the "Day" tab to show in the graph. As soon as the "Day" tab starts to record the "next" day (the 28th in the screenshot) I'd like the graph to show the same totals.

I know that if I wanted the total for a "Day", midnight to midnight local time, which isn't ever likely to happen, I could use the "Hours" tab...etc.
Unless you also add some "Time" boxes to the "Custom" tab so that I could select for example:
from 2014-05-26 21:00 (i.e. up to 4 "hours" rows, for the UTC = midnight beginning May 29th)
..to.. 2014-05-27 20:59 (i.e. up to 20 "hours" rows, for the UTC = midnight ending May 29th)
which would produce a single row (or two "Day" rows, one for up to 4 hours, the other up to 20 hours, plus the aggregate total which is all that I'd really want)wink
Actually only the HH would be required with the program assuming ":00" for the starting time from and ":59" for the ending time to as:
from 2014-05-26 21 (i.e. up to 4 "hours" rows, for the UTC = midnight beginning May 29th)
..to.. 2014-05-27 20 (i.e. up to 20 "hours" rows, for the UTC = midnight ending May 29th)

Thanks,

J

PS In the screenshot of the "Hours.." tab, to get the total for the 27th midnight to midnight, I'd get the sum of
1 row for 2014-05-26 21:00 - 21:59
8 rows for 2014-05-27 10:00 - 10:59 to 19:00 - 19:59
Attachments:
open | download – NW 04 hours.png (49.7 KB)
SoftPerfect Support forum - Andrew avatar image

Re: Adjust graph to reflect the use of the Time Zone Offset   02 June 2014, 16:53

I have updated NetWorx so it should now correctly display time frame and usage info when a timezone offset is used. Please give it a go and let me know how it works for you.

Re: Adjust graph to reflect the use of the Time Zone Offset   03 June 2014, 00:06

Thanks Andrew, I'll have to wait until after 8pm local to verify (it's 10:05am here right now).

Update: It works perfectly, thanks Andrew. This may help others as well... ok, yes, thumb up

J
Or have a timezone offset in the date setting entries.
Regards

Sometimes you can find a solution faster if you try the forum search, have a look at the knowledge base, or check the software user manual to see if your question has already been answered.

Our forum rules are simple:

  • Be polite.
  • Do not spam.
  • Write in English. If possible, check your spelling and grammar.

Author:

Subject

A brief and informative title for your message, approximately 4–8 words:

     

Spam prevention: please enter the following code in the input field below.

  ******   **    **  **      **  **        ********  
 **    **  **   **   **  **  **  **        **     ** 
 **        **  **    **  **  **  **        **     ** 
 **        *****     **  **  **  **        **     ** 
 **        **  **    **  **  **  **        **     ** 
 **    **  **   **   **  **  **  **        **     ** 
  ******   **    **   ***  ***   ********  ********  

Message: