Stats graph "24 hours performance" is showing date in UTC and not local hour of system

[fabyc]

Hi,

I just update MW from 1.3.8.5 to 1.3.9.9. The stats graphs of campaigns are great.

The stats graph of "24 hours performance" is showing date in UTC time. For example I sent a campaign on 2017-04-27 14:58 -5GMT and the first open was at 15:00. In the stats graph is sowing time of first open at 20:00 hours.

Is there a way to configure the time to local hour for that stats graph?

I attach an image in where you can see about I'm explaining: https://s21.postimg.org/85rp3n0iv/2017-04-27_24-hours-perfomance.png

Thanks

 

[twisted1919]

@Fabyc - Right, i should have written a note somewhere that those dates are utc...
Try to unzip attached and put resulted file instead of /apps/customer/components/web/widgets/campaign-tracking/Campaign24HoursPerformanceWidget.php
It will take around one hour for the cache to invalidate and to show you the new timing so make sure you wait for it.

 

[fabyc]

Hi,

Try to unzip attached and put resulted file instead of /apps/customer/components/web/widgets/campaign-tracking/Campaign24HoursPerformanceWidget.php
It will take around one hour for the cache to invalidate and to show you the new timing so make sure you wait for it.

I replace the file for the one in the attached file. I did it almost 6 hours ago , but it is not showing the new timing (the correct one in my local time) yet.

Thanks

 

[Ben Yackshaw]

@twisted1919 is your zipped file above still relevant? I am having this same issue. Thanks!

 

[twisted1919]

@Dan Tamkin - It's been a while, and we changed the system considerably in that area, so i am not sure if it's still working, but you can try it and if any issue, you can revert to the original version of the file.

 

[Ben Yackshaw]

Thanks, I'll give it a try.

 

[Ben Yackshaw]

Both files appear to be the same. I solved this issue by defining the timezone ( timezone = "browser" ) in the "campaign-24hours-performance.js" file.

 

[Napoolion]

Both files appear to be the same. I solved this issue by defining the timezone ( timezone = "browser" ) in the "campaign-24hours-performance.js" file.

Hi, can you please share the file of your own version of this. Thank you very much!

 

[frm.mwz]

Both files appear to be the same. I solved this issue by defining the timezone ( timezone = "browser" ) in the "campaign-24hours-performance.js" file.

Maybe a solution that could be made an option in backend settings, what do you think, @twisted1919 ?

 

[twisted1919]

@frm.mwz - might be, i have too much on my plate right now, will revisit this after we do the next release most likely.

 

[Ben Yackshaw]

@Nappolion in "/assets/js/campaign-24hours-performance.js", I changed the following:

xaxis: {
mode: "time",
timeformat: "%H:00%P"
},

to

xaxis: {
mode: "time",
timeformat: "%I:00%P", //12 hour time
tickSize: [1, "hour"], //tick every hour
timezone: "browser" //local timezone
},

Documentation:
http://www.flotcharts.org/

 

[twisted1919]

@Dan Tamkin - Starting with next release, your settings will be the defaults of the app, thanks for the code

 

[Napoolion]

@Nappolion in "/assets/js/campaign-24hours-performance.js", I changed the following:

xaxis: {
mode: "time",
timeformat: "%H:00%P"
},

to

xaxis: {
mode: "time",
timeformat: "%I:00%P", //12 hour time
tickSize: [1, "hour"], //tick every hour
timezone: "browser" //local timezone
},

Documentation:
http://www.flotcharts.org/

Thank you very much Dan,

For to all your Europeans out there, I got the time format to European format like this:

xaxis: {
mode: "time",
timeformat: "%H:00", //24 hour time
tickSize: [1, "hour"], //tick every hour
timezone: "browser" //local timezone
},

 

[frm.mwz]

Thank you very much Dan,

For to all your Europeans out there, I got the time format to European format like this:

xaxis: {
mode: "time",
timeformat: "%H:00", //24 hour time
tickSize: [1, "hour"], //tick every hour
timezone: "browser" //local timezone
},

Thank god! AM & PM is like flintstoning in the internet age (where one real time year is like 7 years)