[Skip to main content](#vessel-content) # Wrong dates statistics per month ## - **[Udo](/forum/user/29928-udo "View Udo's Profile")** - [![Udo's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/29928-udo "View Udo's Profile") Topic Author - [ Offline](/forum/user/29928-udo) Less More - Posts: 220 - Thank you received: 8 - - - 6 years 2 months ago [\#322664](#322664) by [Udo](/forum/user/29928-udo "View Udo's Profile") *[Wrong dates statistics per month](/forum/36-reports-statistics/900533-wrong-dates-statistics-per-month#322664 "-- HikaShop version -- : 4.3.0 -- Joomla version -- : 3.9.19 -- PHP version -- : 7.2.31 Hi, Strange things are happening in the statistic reports. When daily or weekly figures are displayed, the associated dates are correct. But after switching to monthly statistic suddenly a gap has arisen between the associated date and the actual period to which the statistic shown refers. It's all about a line chart with start date 2020-01-01 and end date 2020-12-31. Two screenshots are attached to make clear what happens. . In screenshot 1 the items are grouped per week. The X-axis displays the correct dates: Jan 01 unto Jan 01. An example of the statistics: on Aug. 10 the sales of the previous week are displayed. In screenshot 2 the items are grouped per month Start date and end date are unchanged. Now the dates on the X-axis haven been moved forward a month: Dec. 01 untill Dec. 01 Remarkable: on Jul. 1 the sales of August are displayed., on Jun. 1 the sales of July and so on. This is very confusing and incorrect. The red lines in the charts are sales in the same period last year. Please advice. Regards, Udo. Regards, Udo")* was created by *[Udo](/forum/user/29928-udo "View Udo's Profile")* -- HikaShop version -- : 4.3.0 -- Joomla version -- : 3.9.19 -- PHP version -- : 7.2.31 Hi, Strange things are happening in the statistic reports. When daily or weekly figures are displayed, the associated dates are correct. But after switching to monthly statistic suddenly a gap has arisen between the associated date and the actual period to which the statistic shown refers. It's all about a line chart with start date 2020-01-01 and end date 2020-12-31. Two screenshots are attached to make clear what happens. . In screenshot 1 the items are grouped per week. The X-axis displays the correct dates: Jan 01 unto Jan 01. An example of the statistics: on Aug. 10 the sales of the previous week are displayed. In screenshot 2 the items are grouped per month Start date and end date are unchanged. Now the dates on the X-axis haven been moved forward a month: Dec. 01 untill Dec. 01 Remarkable: on Jul. 1 the sales of August are displayed., on Jun. 1 the sales of July and so on. This is very confusing and incorrect. The red lines in the charts are sales in the same period last year. Please advice. Regards, Udo. Regards, Udo - [ ![udosprang-screenshot1-weeks.jpg](/forum/attachment/50223) ](/forum/attachment/50223 "...hot1-weeks.jpg") [ ](/forum/attachment/50223?download=1 "...hot1-weeks.jpg") - [ ![udosprang-screenshot2-months.jpg](/forum/attachment/50224) ](/forum/attachment/50224 "...ot2-months.jpg") [ ](/forum/attachment/50224?download=1 "...ot2-months.jpg") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy85MDA1MzMtd3JvbmctZGF0ZXMtc3RhdGlzdGljcy1wZXItbW9udGg/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Udo](/forum/user/29928-udo "View Udo's Profile")** - [![Udo's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/29928-udo "View Udo's Profile") Topic Author - [ Offline](/forum/user/29928-udo) Less More - Posts: 220 - Thank you received: 8 - - - 6 years 2 months ago [\#323228](#323228) by [Udo](/forum/user/29928-udo "View Udo's Profile") Replied by *[Udo](/forum/user/29928-udo "View Udo's Profile")* on topic *[Wrong dates statistics per month](/forum/36-reports-statistics/900533-wrong-dates-statistics-per-month#323228 "-- HikaShop version -- : 4.3.0 -- Joomla version -- : 3.9.19 -- PHP version -- : 7.2.31 Hi, Strange things are happening in the statistic reports. When daily or weekly figures are displayed, the associated dates are correct. But after switching to monthly statistic suddenly a gap has arisen between the associated date and the actual period to which the statistic shown refers. It's all about a line chart with start date 2020-01-01 and end date 2020-12-31. Two screenshots are attached to make clear what happens. . In screenshot 1 the items are grouped per week. The X-axis displays the correct dates: Jan 01 unto Jan 01. An example of the statistics: on Aug. 10 the sales of the previous week are displayed. In screenshot 2 the items are grouped per month Start date and end date are unchanged. Now the dates on the X-axis haven been moved forward a month: Dec. 01 untill Dec. 01 Remarkable: on Jul. 1 the sales of August are displayed., on Jun. 1 the sales of July and so on. This is very confusing and incorrect. The red lines in the charts are sales in the same period last year. Please advice. Regards, Udo. Regards, Udo")* Hi, Something went wrong, I'm afraid. I never received an answer on this topic. regards, Udo Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy85MDA1MzMtd3JvbmctZGF0ZXMtc3RhdGlzdGljcy1wZXItbW9udGg/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 6 years 1 month ago [\#323355](#323355) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Wrong dates statistics per month](/forum/36-reports-statistics/900533-wrong-dates-statistics-per-month#323355 "-- HikaShop version -- : 4.3.0 -- Joomla version -- : 3.9.19 -- PHP version -- : 7.2.31 Hi, Strange things are happening in the statistic reports. When daily or weekly figures are displayed, the associated dates are correct. But after switching to monthly statistic suddenly a gap has arisen between the associated date and the actual period to which the statistic shown refers. It's all about a line chart with start date 2020-01-01 and end date 2020-12-31. Two screenshots are attached to make clear what happens. . In screenshot 1 the items are grouped per week. The X-axis displays the correct dates: Jan 01 unto Jan 01. An example of the statistics: on Aug. 10 the sales of the previous week are displayed. In screenshot 2 the items are grouped per month Start date and end date are unchanged. Now the dates on the X-axis haven been moved forward a month: Dec. 01 untill Dec. 01 Remarkable: on Jul. 1 the sales of August are displayed., on Jun. 1 the sales of July and so on. This is very confusing and incorrect. The red lines in the charts are sales in the same period last year. Please advice. Regards, Udo. Regards, Udo")* Hello, Can you please provide a screenshot of your "report" configuration ? Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy85MDA1MzMtd3JvbmctZGF0ZXMtc3RhdGlzdGljcy1wZXItbW9udGg/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Udo](/forum/user/29928-udo "View Udo's Profile")** - [![Udo's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/29928-udo "View Udo's Profile") Topic Author - [ Offline](/forum/user/29928-udo) Less More - Posts: 220 - Thank you received: 8 - - - 6 years 1 month ago [\#323358](#323358) by [Udo](/forum/user/29928-udo "View Udo's Profile") Replied by *[Udo](/forum/user/29928-udo "View Udo's Profile")* on topic *[Wrong dates statistics per month](/forum/36-reports-statistics/900533-wrong-dates-statistics-per-month#323358 "-- HikaShop version -- : 4.3.0 -- Joomla version -- : 3.9.19 -- PHP version -- : 7.2.31 Hi, Strange things are happening in the statistic reports. When daily or weekly figures are displayed, the associated dates are correct. But after switching to monthly statistic suddenly a gap has arisen between the associated date and the actual period to which the statistic shown refers. It's all about a line chart with start date 2020-01-01 and end date 2020-12-31. Two screenshots are attached to make clear what happens. . In screenshot 1 the items are grouped per week. The X-axis displays the correct dates: Jan 01 unto Jan 01. An example of the statistics: on Aug. 10 the sales of the previous week are displayed. In screenshot 2 the items are grouped per month Start date and end date are unchanged. Now the dates on the X-axis haven been moved forward a month: Dec. 01 untill Dec. 01 Remarkable: on Jul. 1 the sales of August are displayed., on Jun. 1 the sales of July and so on. This is very confusing and incorrect. The red lines in the charts are sales in the same period last year. Please advice. Regards, Udo. Regards, Udo")* Hi, Attached is a screenshot of the configuration of the monthly sales report. Before updating to Hikashop 4.3.0 I used the columns display type. That was working fine. Alas that display type is removed. Regards, Udo - [ ![udosprang-reportconfiguration-salespermonth.jpg](/forum/attachment/50393) ](/forum/attachment/50393 "...espermonth.jpg") [ ](/forum/attachment/50393?download=1 "...espermonth.jpg") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy85MDA1MzMtd3JvbmctZGF0ZXMtc3RhdGlzdGljcy1wZXItbW9udGg/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 6 years 1 month ago [\#323363](#323363) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Wrong dates statistics per month](/forum/36-reports-statistics/900533-wrong-dates-statistics-per-month#323363 "-- HikaShop version -- : 4.3.0 -- Joomla version -- : 3.9.19 -- PHP version -- : 7.2.31 Hi, Strange things are happening in the statistic reports. When daily or weekly figures are displayed, the associated dates are correct. But after switching to monthly statistic suddenly a gap has arisen between the associated date and the actual period to which the statistic shown refers. It's all about a line chart with start date 2020-01-01 and end date 2020-12-31. Two screenshots are attached to make clear what happens. . In screenshot 1 the items are grouped per week. The X-axis displays the correct dates: Jan 01 unto Jan 01. An example of the statistics: on Aug. 10 the sales of the previous week are displayed. In screenshot 2 the items are grouped per month Start date and end date are unchanged. Now the dates on the X-axis haven been moved forward a month: Dec. 01 untill Dec. 01 Remarkable: on Jul. 1 the sales of August are displayed., on Jun. 1 the sales of July and so on. This is very confusing and incorrect. The red lines in the charts are sales in the same period last year. Please advice. Regards, Udo. Regards, Udo")* Hello, Do you know which version you were using before your update to HikaShop 4.3.0 ? Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy85MDA1MzMtd3JvbmctZGF0ZXMtc3RhdGlzdGljcy1wZXItbW9udGg/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Udo](/forum/user/29928-udo "View Udo's Profile")** - [![Udo's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/29928-udo "View Udo's Profile") Topic Author - [ Offline](/forum/user/29928-udo) Less More - Posts: 220 - Thank you received: 8 - - - 6 years 1 month ago [\#323392](#323392) by [Udo](/forum/user/29928-udo "View Udo's Profile") Replied by *[Udo](/forum/user/29928-udo "View Udo's Profile")* on topic *[Wrong dates statistics per month](/forum/36-reports-statistics/900533-wrong-dates-statistics-per-month#323392 "-- HikaShop version -- : 4.3.0 -- Joomla version -- : 3.9.19 -- PHP version -- : 7.2.31 Hi, Strange things are happening in the statistic reports. When daily or weekly figures are displayed, the associated dates are correct. But after switching to monthly statistic suddenly a gap has arisen between the associated date and the actual period to which the statistic shown refers. It's all about a line chart with start date 2020-01-01 and end date 2020-12-31. Two screenshots are attached to make clear what happens. . In screenshot 1 the items are grouped per week. The X-axis displays the correct dates: Jan 01 unto Jan 01. An example of the statistics: on Aug. 10 the sales of the previous week are displayed. In screenshot 2 the items are grouped per month Start date and end date are unchanged. Now the dates on the X-axis haven been moved forward a month: Dec. 01 untill Dec. 01 Remarkable: on Jul. 1 the sales of August are displayed., on Jun. 1 the sales of July and so on. This is very confusing and incorrect. The red lines in the charts are sales in the same period last year. Please advice. Regards, Udo. Regards, Udo")* I was using Hikashop 3.5.1 Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy85MDA1MzMtd3JvbmctZGF0ZXMtc3RhdGlzdGljcy1wZXItbW9udGg/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 6 years 1 month ago [\#323403](#323403) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Wrong dates statistics per month](/forum/36-reports-statistics/900533-wrong-dates-statistics-per-month#323403 "-- HikaShop version -- : 4.3.0 -- Joomla version -- : 3.9.19 -- PHP version -- : 7.2.31 Hi, Strange things are happening in the statistic reports. When daily or weekly figures are displayed, the associated dates are correct. But after switching to monthly statistic suddenly a gap has arisen between the associated date and the actual period to which the statistic shown refers. It's all about a line chart with start date 2020-01-01 and end date 2020-12-31. Two screenshots are attached to make clear what happens. . In screenshot 1 the items are grouped per week. The X-axis displays the correct dates: Jan 01 unto Jan 01. An example of the statistics: on Aug. 10 the sales of the previous week are displayed. In screenshot 2 the items are grouped per month Start date and end date are unchanged. Now the dates on the X-axis haven been moved forward a month: Dec. 01 untill Dec. 01 Remarkable: on Jul. 1 the sales of August are displayed., on Jun. 1 the sales of July and so on. This is very confusing and incorrect. The red lines in the charts are sales in the same period last year. Please advice. Regards, Udo. Regards, Udo")* Hello, Between HikaShop 3.5.1 and HikaShop 4.3.0 ; there was a fix related to the handle of the timezone in the reports. So, I suppose the issue you see is related to a swift of few hours which would correspond to the timezone. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy85MDA1MzMtd3JvbmctZGF0ZXMtc3RhdGlzdGljcy1wZXItbW9udGg/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Udo](/forum/user/29928-udo "View Udo's Profile")** - [![Udo's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/29928-udo "View Udo's Profile") Topic Author - [ Offline](/forum/user/29928-udo) Less More - Posts: 220 - Thank you received: 8 - - - 6 years 1 month ago [\#323458](#323458) by [Udo](/forum/user/29928-udo "View Udo's Profile") Replied by *[Udo](/forum/user/29928-udo "View Udo's Profile")* on topic *[Wrong dates statistics per month](/forum/36-reports-statistics/900533-wrong-dates-statistics-per-month#323458 "-- HikaShop version -- : 4.3.0 -- Joomla version -- : 3.9.19 -- PHP version -- : 7.2.31 Hi, Strange things are happening in the statistic reports. When daily or weekly figures are displayed, the associated dates are correct. But after switching to monthly statistic suddenly a gap has arisen between the associated date and the actual period to which the statistic shown refers. It's all about a line chart with start date 2020-01-01 and end date 2020-12-31. Two screenshots are attached to make clear what happens. . In screenshot 1 the items are grouped per week. The X-axis displays the correct dates: Jan 01 unto Jan 01. An example of the statistics: on Aug. 10 the sales of the previous week are displayed. In screenshot 2 the items are grouped per month Start date and end date are unchanged. Now the dates on the X-axis haven been moved forward a month: Dec. 01 untill Dec. 01 Remarkable: on Jul. 1 the sales of August are displayed., on Jun. 1 the sales of July and so on. This is very confusing and incorrect. The red lines in the charts are sales in the same period last year. Please advice. Regards, Udo. Regards, Udo")* Hi, If the issue is caused by this timezone fix it did not affect items grouped by week, only intems grouped by month. Is there any way to address the problem? regards, Udo Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy85MDA1MzMtd3JvbmctZGF0ZXMtc3RhdGlzdGljcy1wZXItbW9udGg/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")** - [![Mohamed Thelji's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6861.png)](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") - [ Offline](/forum/user/6861-mohamed-thelji) Less More - Posts: 12953 - Thank you received: 1778 - - - 6 years 1 month ago [\#323981](#323981) by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") Replied by *[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")* on topic *[Wrong dates statistics per month](/forum/36-reports-statistics/900533-wrong-dates-statistics-per-month#323981 "-- HikaShop version -- : 4.3.0 -- Joomla version -- : 3.9.19 -- PHP version -- : 7.2.31 Hi, Strange things are happening in the statistic reports. When daily or weekly figures are displayed, the associated dates are correct. But after switching to monthly statistic suddenly a gap has arisen between the associated date and the actual period to which the statistic shown refers. It's all about a line chart with start date 2020-01-01 and end date 2020-12-31. Two screenshots are attached to make clear what happens. . In screenshot 1 the items are grouped per week. The X-axis displays the correct dates: Jan 01 unto Jan 01. An example of the statistics: on Aug. 10 the sales of the previous week are displayed. In screenshot 2 the items are grouped per month Start date and end date are unchanged. Now the dates on the X-axis haven been moved forward a month: Dec. 01 untill Dec. 01 Remarkable: on Jul. 1 the sales of August are displayed., on Jun. 1 the sales of July and so on. This is very confusing and incorrect. The red lines in the charts are sales in the same period last year. Please advice. Regards, Udo. Regards, Udo")* Hello Udo, I just tested it with the same configuration and it worked fine, can you download the last Hikashop version through our website, install it and test it again ? If you're still having that issue can you send us a temporary access to your back-end so that we can directly test it ? Thank you. You can send it using our contact form via : [ www.hikashop.com/support/contact-us.html](https://www.hikashop.com/support/contact-us.html) Also, don't forget to add a link to that thread in your message, thank you. Kind regards, Mohamed. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy85MDA1MzMtd3JvbmctZGF0ZXMtc3RhdGlzdGljcy1wZXItbW9udGg/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Udo](/forum/user/29928-udo "View Udo's Profile")** - [![Udo's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/29928-udo "View Udo's Profile") Topic Author - [ Offline](/forum/user/29928-udo) Less More - Posts: 220 - Thank you received: 8 - - - 6 years 1 month ago [\#323996](#323996) by [Udo](/forum/user/29928-udo "View Udo's Profile") Replied by *[Udo](/forum/user/29928-udo "View Udo's Profile")* on topic *[Wrong dates statistics per month](/forum/36-reports-statistics/900533-wrong-dates-statistics-per-month#323996 "-- HikaShop version -- : 4.3.0 -- Joomla version -- : 3.9.19 -- PHP version -- : 7.2.31 Hi, Strange things are happening in the statistic reports. When daily or weekly figures are displayed, the associated dates are correct. But after switching to monthly statistic suddenly a gap has arisen between the associated date and the actual period to which the statistic shown refers. It's all about a line chart with start date 2020-01-01 and end date 2020-12-31. Two screenshots are attached to make clear what happens. . In screenshot 1 the items are grouped per week. The X-axis displays the correct dates: Jan 01 unto Jan 01. An example of the statistics: on Aug. 10 the sales of the previous week are displayed. In screenshot 2 the items are grouped per month Start date and end date are unchanged. Now the dates on the X-axis haven been moved forward a month: Dec. 01 untill Dec. 01 Remarkable: on Jul. 1 the sales of August are displayed., on Jun. 1 the sales of July and so on. This is very confusing and incorrect. The red lines in the charts are sales in the same period last year. Please advice. Regards, Udo. Regards, Udo")* Hi Mohamed, I'm using the last Hikashop version 4.3.0 The access details are mailed via the contact form. Looking at the recent reports I notice that the months Aug and Oct are displayed but Sept is missing. Aug shows the statistics of the current month September. Thnaks, Udo Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy85MDA1MzMtd3JvbmctZGF0ZXMtc3RhdGlzdGljcy1wZXItbW9udGg/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Udo](/forum/user/29928-udo "View Udo's Profile")** - [![Udo's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/29928-udo "View Udo's Profile") Topic Author - [ Offline](/forum/user/29928-udo) Less More - Posts: 220 - Thank you received: 8 - - - 6 years 2 weeks ago [\#324479](#324479) by [Udo](/forum/user/29928-udo "View Udo's Profile") Replied by *[Udo](/forum/user/29928-udo "View Udo's Profile")* on topic *[Wrong dates statistics per month](/forum/36-reports-statistics/900533-wrong-dates-statistics-per-month#324479 "-- HikaShop version -- : 4.3.0 -- Joomla version -- : 3.9.19 -- PHP version -- : 7.2.31 Hi, Strange things are happening in the statistic reports. When daily or weekly figures are displayed, the associated dates are correct. But after switching to monthly statistic suddenly a gap has arisen between the associated date and the actual period to which the statistic shown refers. It's all about a line chart with start date 2020-01-01 and end date 2020-12-31. Two screenshots are attached to make clear what happens. . In screenshot 1 the items are grouped per week. The X-axis displays the correct dates: Jan 01 unto Jan 01. An example of the statistics: on Aug. 10 the sales of the previous week are displayed. In screenshot 2 the items are grouped per month Start date and end date are unchanged. Now the dates on the X-axis haven been moved forward a month: Dec. 01 untill Dec. 01 Remarkable: on Jul. 1 the sales of August are displayed., on Jun. 1 the sales of July and so on. This is very confusing and incorrect. The red lines in the charts are sales in the same period last year. Please advice. Regards, Udo. Regards, Udo")* Any advice? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy85MDA1MzMtd3JvbmctZGF0ZXMtc3RhdGlzdGljcy1wZXItbW9udGg/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Udo](/forum/user/29928-udo "View Udo's Profile")** - [![Udo's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/29928-udo "View Udo's Profile") Topic Author - [ Offline](/forum/user/29928-udo) Less More - Posts: 220 - Thank you received: 8 - - - 6 years 1 day ago [\#324962](#324962) by [Udo](/forum/user/29928-udo "View Udo's Profile") Replied by *[Udo](/forum/user/29928-udo "View Udo's Profile")* on topic *[Wrong dates statistics per month](/forum/36-reports-statistics/900533-wrong-dates-statistics-per-month#324962 "-- HikaShop version -- : 4.3.0 -- Joomla version -- : 3.9.19 -- PHP version -- : 7.2.31 Hi, Strange things are happening in the statistic reports. When daily or weekly figures are displayed, the associated dates are correct. But after switching to monthly statistic suddenly a gap has arisen between the associated date and the actual period to which the statistic shown refers. It's all about a line chart with start date 2020-01-01 and end date 2020-12-31. Two screenshots are attached to make clear what happens. . In screenshot 1 the items are grouped per week. The X-axis displays the correct dates: Jan 01 unto Jan 01. An example of the statistics: on Aug. 10 the sales of the previous week are displayed. In screenshot 2 the items are grouped per month Start date and end date are unchanged. Now the dates on the X-axis haven been moved forward a month: Dec. 01 untill Dec. 01 Remarkable: on Jul. 1 the sales of August are displayed., on Jun. 1 the sales of July and so on. This is very confusing and incorrect. The red lines in the charts are sales in the same period last year. Please advice. Regards, Udo. Regards, Udo")* Hi, Your temporay access to the website is now disabled. Unfortunately you didnot reply anymore. Regards, Udo Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy85MDA1MzMtd3JvbmctZGF0ZXMtc3RhdGlzdGljcy1wZXItbW9udGg/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")** - [![Mohamed Thelji's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6861.png)](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") - [ Offline](/forum/user/6861-mohamed-thelji) Less More - Posts: 12953 - Thank you received: 1778 - - - 6 years 1 day ago - 6 years 1 day ago [\#324964](#324964) by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") Replied by *[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")* on topic *[Wrong dates statistics per month](/forum/36-reports-statistics/900533-wrong-dates-statistics-per-month#324964 "-- HikaShop version -- : 4.3.0 -- Joomla version -- : 3.9.19 -- PHP version -- : 7.2.31 Hi, Strange things are happening in the statistic reports. When daily or weekly figures are displayed, the associated dates are correct. But after switching to monthly statistic suddenly a gap has arisen between the associated date and the actual period to which the statistic shown refers. It's all about a line chart with start date 2020-01-01 and end date 2020-12-31. Two screenshots are attached to make clear what happens. . In screenshot 1 the items are grouped per week. The X-axis displays the correct dates: Jan 01 unto Jan 01. An example of the statistics: on Aug. 10 the sales of the previous week are displayed. In screenshot 2 the items are grouped per month Start date and end date are unchanged. Now the dates on the X-axis haven been moved forward a month: Dec. 01 untill Dec. 01 Remarkable: on Jul. 1 the sales of August are displayed., on Jun. 1 the sales of July and so on. This is very confusing and incorrect. The red lines in the charts are sales in the same period last year. Please advice. Regards, Udo. Regards, Udo")* Hello Udo and sorry for the late reply, We were actually able to reproduc that issue on our end, and made a fix. The solution will be to edit the file "administrator\components\com_hikashop\classes\widget.php" and change these lines : Code: function _jsDate($group,&$element, $widget=null, $diff=null){ if(!isset($element->timestamp)){ switch($group){ case '%H %j %Y'://day $parts = explode(' ',$element->calculated_date); $element->timestamp = gmmktime($parts[2], 0, 0, 1, $parts[1], $parts[0]) - $this->timeoffset; break; case '%j %Y'://day $parts = explode(' ',$element->calculated_date); $element->timestamp = gmmktime(0, 0, 0, 1, $parts[1], $parts[0])- $this->timeoffset; break; case '%u %Y'://week $parts = explode(' ',$element->calculated_date); $element->timestamp = gmmktime(0, 0, 0, 1, $parts[1]*7, $parts[0])- $this->timeoffset; break; case '%m %Y'://month $parts = explode(' ',$element->calculated_date); $element->timestamp = gmmktime(0, 0, 0, $parts[1], 1, $parts[0])- $this->timeoffset; break; case '%Y'://year $element->timestamp = gmmktime(0, 0, 0, 1, 1, $element->calculated_date)- $this->timeoffset; break; } } if(isset($widget->widget_params->period_compare)){ if($widget->widget_params->period_compare=='last_period' && isset($widget->elements)){ $element->timestamp=$element->timestamp+$diff; } } $element->year = date('Y',$element->timestamp); $element->month = date('m',$element->timestamp)-1; $element->day = date('j',$element->timestamp); if($widget->widget_params->date_group=="%H %j %Y"){ $element->hour = date('G',$element->timestamp); } } By : Code: function _jsDate($group,&$element, $widget=null, $diff=null){ if(!isset($element->timestamp)){ switch($group){ case '%H %j %Y'://day $parts = explode(' ',$element->calculated_date); $element->timestamp = gmmktime($parts[2], 0, 0, 1, $parts[1], $parts[0]); break; case '%j %Y'://day $parts = explode(' ',$element->calculated_date); $element->timestamp = gmmktime(0, 0, 0, 1, $parts[1], $parts[0]); break; case '%u %Y'://week $parts = explode(' ',$element->calculated_date); $element->timestamp = gmmktime(0, 0, 0, 1, $parts[1]*7, $parts[0]); break; case '%m %Y'://month $parts = explode(' ',$element->calculated_date); $element->timestamp = gmmktime(0, 0, 0, $parts[1], 1, $parts[0]); break; case '%Y'://year $element->timestamp = gmmktime(0, 0, 0, 1, 1, $element->calculated_date); break; } } if(isset($widget->widget_params->period_compare)){ if($widget->widget_params->period_compare=='last_period' && isset($widget->elements)){ $element->timestamp=$element->timestamp+$diff; } } // Setting the timezone $joomlaConfig = JFactory::getConfig(); if(!HIKASHOP_J30) $offset = $joomlaConfig->getValue('config.offset'); else $offset = $joomlaConfig->get('offset'); date_default_timezone_set(JFactory::getUser()->getParam('timezone', $offset)); $element->year = date('Y',$element->timestamp); $element->month = date('m',$element->timestamp)-1; $element->day = date('j',$element->timestamp); if($widget->widget_params->date_group=="%H %j %Y"){ $element->hour = date('G',$element->timestamp); } } Thanks for your feedback ! Kind regards, Mohamed Last edit: 6 years 1 day ago by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile"). The following user(s) said Thank You: [Udo](/forum/user/29928-udo "View Udo's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy85MDA1MzMtd3JvbmctZGF0ZXMtc3RhdGlzdGljcy1wZXItbW9udGg/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Udo](/forum/user/29928-udo "View Udo's Profile")** - [![Udo's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/29928-udo "View Udo's Profile") Topic Author - [ Offline](/forum/user/29928-udo) Less More - Posts: 220 - Thank you received: 8 - - - 6 years 19 hours ago [\#325007](#325007) by [Udo](/forum/user/29928-udo "View Udo's Profile") Replied by *[Udo](/forum/user/29928-udo "View Udo's Profile")* on topic *[Wrong dates statistics per month](/forum/36-reports-statistics/900533-wrong-dates-statistics-per-month#325007 "-- HikaShop version -- : 4.3.0 -- Joomla version -- : 3.9.19 -- PHP version -- : 7.2.31 Hi, Strange things are happening in the statistic reports. When daily or weekly figures are displayed, the associated dates are correct. But after switching to monthly statistic suddenly a gap has arisen between the associated date and the actual period to which the statistic shown refers. It's all about a line chart with start date 2020-01-01 and end date 2020-12-31. Two screenshots are attached to make clear what happens. . In screenshot 1 the items are grouped per week. The X-axis displays the correct dates: Jan 01 unto Jan 01. An example of the statistics: on Aug. 10 the sales of the previous week are displayed. In screenshot 2 the items are grouped per month Start date and end date are unchanged. Now the dates on the X-axis haven been moved forward a month: Dec. 01 untill Dec. 01 Remarkable: on Jul. 1 the sales of August are displayed., on Jun. 1 the sales of July and so on. This is very confusing and incorrect. The red lines in the charts are sales in the same period last year. Please advice. Regards, Udo. Regards, Udo")* Thanks a lot, Mohamed. Problem solved! regards, Udo The following user(s) said Thank You: [Philip](/forum/user/34318-philip "View Philip's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy85MDA1MzMtd3JvbmctZGF0ZXMtc3RhdGlzdGljcy1wZXItbW9udGg/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop- Install & Update- Product & Category Display- Content Creation- Sales and Orders- - Orders management- - Reports & Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import & Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel & Slider- - Mass Actions- - Filters & Search- - Discount & Coupon- - Feature Request- Integrations- Showcase- General Talk about HikaShop- Development- - HikaShop 3.0 Beta- Translation- Commercial Jobs HikaShop Components- HikaMarket- - Market: Feature requests- - Market: How to?- - Market: Bug Report- HikaSerial- - General talk about HikaSerial- - Serial: Bug Report- - Serial: How to?- - Support en Français de HikaSerial (French Support)- - HikaSubscription- HikaAuction- - Auction: Feature requests- - Auction: How to?- - Auction: Bug report Hikashop around the world- Support en Français (French Support)- Russian- - FAQ. Курс выживания с Hikashop. Частые вопросы и о- - Расширения Hikashop- - Наши сайты на Hikashop- 日本語版サポート(Japanese Support)- Thai- German Archives- Bug Report- How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.444 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)