[Skip to main content](#vessel-content) # Grouping ot items incorrect in line report ## - **[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 - - - 5 years 7 months ago - 5 years 7 months ago [\#331536](#331536) by [Udo](/forum/user/29928-udo "View Udo's Profile") *[Grouping ot items incorrect in line report](/forum/36-reports-statistics/902335-grouping-ot-items-incorrect-in-line-report#331536 "-- HikaShop version -- : 4.3.0 -- Joomla version -- : 3.9.23 -- PHP version -- : 7.3.27 Hi, This problem concerns the legacy dashboard. First I published a table report of the sales in a month. Period: this month The sales figures are displayed correctly. Then I published a line report of sales this year. The items are grouped per month. Alas the resulting sales figures differ from the table report. Looking into the cause of the difference I discovered that the exact start time and end time are incorrect when grouping per month in the line report. The start date is not March 1 00:00 but Febr 28 22:00 and the end date is March 31 22:00 So the month is pushed back 2 hours! I tested several months, the same thing happened every month. And this problem also arises when grouping per week. The selected date type in the line report: created Please advise. Udo")* was created by *[Udo](/forum/user/29928-udo "View Udo's Profile")* -- HikaShop version -- : 4.3.0 -- Joomla version -- : 3.9.23 -- PHP version -- : 7.3.27 Hi, This problem concerns the legacy dashboard. First I published a **table report** of the sales in a month. Period: this month The sales figures are displayed correctly. Then I published a **line report** of sales this year. The items are grouped per month. Alas the resulting sales figures differ from the table report. Looking into the cause of the difference I discovered that the exact start time and end time are incorrect when grouping per month in the line report. The start date is not March 1 00:00 but Febr 28 22:00 and the end date is March 31 22:00 So the month is pushed back 2 hours! I tested several months, the same thing happened every month. And this problem also arises when grouping per week. The selected date type in the line report: created Please advise. Udo Last edit: 5 years 7 months ago by [Udo](/forum/user/29928-udo "View Udo's Profile"). Reason: forgotten information about date type Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy85MDIzMzUtZ3JvdXBpbmctb3QtaXRlbXMtaW5jb3JyZWN0LWluLWxpbmUtcmVwb3J0P3RtcGw9bWFya2Rvd24=) 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 - - - 5 years 6 months ago [\#332037](#332037) by [Udo](/forum/user/29928-udo "View Udo's Profile") Replied by *[Udo](/forum/user/29928-udo "View Udo's Profile")* on topic *[Grouping ot items incorrect in line report](/forum/36-reports-statistics/902335-grouping-ot-items-incorrect-in-line-report#332037 "-- HikaShop version -- : 4.3.0 -- Joomla version -- : 3.9.23 -- PHP version -- : 7.3.27 Hi, This problem concerns the legacy dashboard. First I published a table report of the sales in a month. Period: this month The sales figures are displayed correctly. Then I published a line report of sales this year. The items are grouped per month. Alas the resulting sales figures differ from the table report. Looking into the cause of the difference I discovered that the exact start time and end time are incorrect when grouping per month in the line report. The start date is not March 1 00:00 but Febr 28 22:00 and the end date is March 31 22:00 So the month is pushed back 2 hours! I tested several months, the same thing happened every month. And this problem also arises when grouping per week. The selected date type in the line report: created Please advise. Udo")* Hi, Almost 3 weeks ago now, still no reply... Has this topic been overlooked? regards, Udo Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy85MDIzMzUtZ3JvdXBpbmctb3QtaXRlbXMtaW5jb3JyZWN0LWluLWxpbmUtcmVwb3J0P3RtcGw9bWFya2Rvd24=) 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.045 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)