[Skip to main content](#vessel-content) # Today value in reporting does not work ## - **[jschroeder](/forum/user/13561-jschroeder "View jschroeder's Profile")** - [![jschroeder's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/13561-jschroeder "View jschroeder's Profile") Topic Author - [ Offline](/forum/user/13561-jschroeder) Less More - Posts: 165 - Thank you received: 3 - - 9 years 11 months ago [\#256473](#256473) by [jschroeder](/forum/user/13561-jschroeder "View jschroeder's Profile") *[Today value in reporting does not work](/forum/36-reports-statistics/887717-today-value-in-reporting-does-not-work#256473 "-- HikaShop version -- : 2.6.3 -- Joomla version -- : 3.6.4 I am trying to figure out how to get the Value of "TODAY" working for the reporting. No matter if I select TODAY in any type of reporting whether it be a table or gauge, etc it does not show the sales of just that days from 0:00 to 23:59 hours. It seems to just take whenever the last 24 hrs was when the widget was published. How do I fix this? This does not make sense to me because there is a last 24 hrs options, I would think if you selected TODAY that it would start from the beginning of the day? How do I fix this because the gauge and the table and using sales, it is not reporting the correct dollar amounts. For example it was 22:00 hours and the gauge was set to TODAY and days and the sales reset to 0 on the gauge when it should not have reset until 23:59:59. The only way I can get it to report "TODAY" is to set it to manual to the date range and time that I want, which I need it to be automatic. How can this be fixed? Thanks, Josh")* was created by *[jschroeder](/forum/user/13561-jschroeder "View jschroeder's Profile")* -- HikaShop version -- : 2.6.3 -- Joomla version -- : 3.6.4 I am trying to figure out how to get the Value of "TODAY" working for the reporting. No matter if I select TODAY in any type of reporting whether it be a table or gauge, etc it does not show the sales of just that days from 0:00 to 23:59 hours. It seems to just take whenever the last 24 hrs was when the widget was published. How do I fix this? This does not make sense to me because there is a last 24 hrs options, I would think if you selected TODAY that it would start from the beginning of the day? How do I fix this because the gauge and the table and using sales, it is not reporting the correct dollar amounts. For example it was 22:00 hours and the gauge was set to TODAY and days and the sales reset to 0 on the gauge when it should not have reset until 23:59:59. The only way I can get it to report "TODAY" is to set it to manual to the date range and time that I want, which I need it to be automatic. How can this be fixed? Thanks, Josh Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84ODc3MTctdG9kYXktdmFsdWUtaW4tcmVwb3J0aW5nLWRvZXMtbm90LXdvcms/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86555 - Thank you received: 14304 - - 9 years 11 months ago [\#256500](#256500) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Today value in reporting does not work](/forum/36-reports-statistics/887717-today-value-in-reporting-does-not-work#256500 "-- HikaShop version -- : 2.6.3 -- Joomla version -- : 3.6.4 I am trying to figure out how to get the Value of "TODAY" working for the reporting. No matter if I select TODAY in any type of reporting whether it be a table or gauge, etc it does not show the sales of just that days from 0:00 to 23:59 hours. It seems to just take whenever the last 24 hrs was when the widget was published. How do I fix this? This does not make sense to me because there is a last 24 hrs options, I would think if you selected TODAY that it would start from the beginning of the day? How do I fix this because the gauge and the table and using sales, it is not reporting the correct dollar amounts. For example it was 22:00 hours and the gauge was set to TODAY and days and the sales reset to 0 on the gauge when it should not have reset until 23:59:59. The only way I can get it to report "TODAY" is to set it to manual to the date range and time that I want, which I need it to be automatic. How can this be fixed? Thanks, Josh")* Hi, I'm not able to reproduce the problem. And looking at the code handling that, it is fine: [ take.ms/NqKkT](http://take.ms/NqKkT) Could you provide a screenshot of the settings of your report ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84ODc3MTctdG9kYXktdmFsdWUtaW4tcmVwb3J0aW5nLWRvZXMtbm90LXdvcms/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[jschroeder](/forum/user/13561-jschroeder "View jschroeder's Profile")** - [![jschroeder's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/13561-jschroeder "View jschroeder's Profile") Topic Author - [ Offline](/forum/user/13561-jschroeder) Less More - Posts: 165 - Thank you received: 3 - - 9 years 11 months ago [\#256561](#256561) by [jschroeder](/forum/user/13561-jschroeder "View jschroeder's Profile") Replied by *[jschroeder](/forum/user/13561-jschroeder "View jschroeder's Profile")* on topic *[Today value in reporting does not work](/forum/36-reports-statistics/887717-today-value-in-reporting-does-not-work#256561 "-- HikaShop version -- : 2.6.3 -- Joomla version -- : 3.6.4 I am trying to figure out how to get the Value of "TODAY" working for the reporting. No matter if I select TODAY in any type of reporting whether it be a table or gauge, etc it does not show the sales of just that days from 0:00 to 23:59 hours. It seems to just take whenever the last 24 hrs was when the widget was published. How do I fix this? This does not make sense to me because there is a last 24 hrs options, I would think if you selected TODAY that it would start from the beginning of the day? How do I fix this because the gauge and the table and using sales, it is not reporting the correct dollar amounts. For example it was 22:00 hours and the gauge was set to TODAY and days and the sales reset to 0 on the gauge when it should not have reset until 23:59:59. The only way I can get it to report "TODAY" is to set it to manual to the date range and time that I want, which I need it to be automatic. How can this be fixed? Thanks, Josh")* Thank you for the response. Here is the screenshot of the settings. Is this a possible this is a bug in version 2.6.3 of the cart? I have not upgraded to 2.6.4 because this is a big client and they have had sales going on. I have to wait until after Christmas to upgrade. - [ ![guage.PNG](/forum/attachment/34895) ](/forum/attachment/34895 "guage.PNG") [ ](/forum/attachment/34895?download=1 "guage.PNG") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84ODc3MTctdG9kYXktdmFsdWUtaW4tcmVwb3J0aW5nLWRvZXMtbm90LXdvcms/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86555 - Thank you received: 14304 - - 9 years 11 months ago [\#256646](#256646) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Today value in reporting does not work](/forum/36-reports-statistics/887717-today-value-in-reporting-does-not-work#256646 "-- HikaShop version -- : 2.6.3 -- Joomla version -- : 3.6.4 I am trying to figure out how to get the Value of "TODAY" working for the reporting. No matter if I select TODAY in any type of reporting whether it be a table or gauge, etc it does not show the sales of just that days from 0:00 to 23:59 hours. It seems to just take whenever the last 24 hrs was when the widget was published. How do I fix this? This does not make sense to me because there is a last 24 hrs options, I would think if you selected TODAY that it would start from the beginning of the day? How do I fix this because the gauge and the table and using sales, it is not reporting the correct dollar amounts. For example it was 22:00 hours and the gauge was set to TODAY and days and the sales reset to 0 on the gauge when it should not have reset until 23:59:59. The only way I can get it to report "TODAY" is to set it to manual to the date range and time that I want, which I need it to be automatic. How can this be fixed? Thanks, Josh")* Hi, I've tried to reproduce the issue with the same configuration on my end and I get that MySQL query: Code: SELECT DATE_FORMAT(FROM_UNIXTIME(CAST(a.order_created AS SIGNED )+0),'%Y %j') AS calculated_date, SUM(a.order_full_price) AS total,a.order_currency_id AS currency_id FROM s4d38_hikashop_order AS a WHERE a.order_type='sale' AND a.order_created > 1480546800 AND a.order_created < 1480603675 GROUP BY calculated_date, currency_id ORDER BY calculated_date DESC the order_created checks are valid and correspond to what it is supposed to do. I've also checked the modifications done to the reporting system since the 2.6.3 and no modifications are linked to the period calculations. So as far as I understand, what you have is correct and updating won't help. You must be missing something. For example, you've set the statuses setting to all statuses, meaning that even cancelled, refunded and created orders will be taken into account while you might only want to take into account confirmed and shipped orders. It could also be something relative to your timezone. The report system uses this code to calculate "today at 00:00": Code: $start= mktime(0, 0, 0, $dayBeginning[0], $dayBeginning[1], $dayBeginning[2]); This takes into account the timezone of your server. But it doesn't take into account the timezone of your user in Joomla nor the timezone of the Joomla configuration. So it might be why you think that it does the same as "the last 24h" because the time difference you have between your server and your user fill in the gap between "the last 24h" and "today". Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84ODc3MTctdG9kYXktdmFsdWUtaW4tcmVwb3J0aW5nLWRvZXMtbm90LXdvcms/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.057 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)