magento2: Admin dashboard order total incorrect on page load

Preconditions and environment

Magento version 2.4.5,2.4-develop PHP 8.1

1.Install Magento Instance. 2.Enable Admin dashboard Chart and use aggregated data 3.Create Orders for any product and do invoice and ship, because from completed orders we can get the Revenue. 4.Check Revenue for Today and 24hrs Timeline. 5.To see the Difference in Revenue we need to have Revenue for 24hrs and for Today(0 in my case).

Steps to reproduce

On Page load of the admin dashboard it appears the total is for the last 24hrs and not the displayed today.

1.Open admin page - Enable the chart and use aggregated data. 2.check the Today Revenue.(Revenue should be today’s revenue),it is adding 24hrs Revenue. 3.Change to 24 hrs Timeline and check Revenue. 4.Again change to Today it is adding today’s revenue.(i.e, 0 in my case). 5.Reload page and again it is adding 24hrs Revenue.

Expected result

Chart and total to be in sync reflecting today, like:

Actual result

Chart correct (nothing), total wrong:

Additional information.

https://user-images.githubusercontent.com/51680745/193268743-f4e2b1e1-fddf-4080-aea6-80b9f0a17376.mov

Additional information

Selecting another timeframe from the option box and then reverting to today gives the correct information.

The sql select for “Today”: SELECT SUM(main_table.total_revenue_amount) AS revenue, SUM(main_table.total_tax_amount_actual) AS tax, SUM(main_table.total_shipping_amount_actual) AS shipping, SUM(orders_count) AS quantity FROM sales_order_aggregated_created AS main_table WHERE (period >= '2023-02-16 00:00:00' AND period <= '2023-02-16 23:59:59') AND (main_table.order_status NOT IN('Canceled')) AND (store_id = '0')

And here the result without the SUM:

The sql select for “Last 24 hours”: SELECT SUM(main_table.total_revenue_amount) AS revenue, SUM(main_table.total_tax_amount_actual) AS tax, SUM(main_table.total_shipping_amount_actual) AS shipping, SUM(orders_count) AS quantity FROM sales_order_aggregated_created AS main_table WHERE (period >= '2023-02-15 11:58:12' AND period <= '2023-02-16 11:58:12') AND (main_table.order_status NOT IN('Canceled')) AND (store_id = '0')

And here the result without the SUM:

The result stay the same and so the total values. The problem is, that the field “period” in “sales_order_aggregated_created” is a date field and not datetime. The graph is also messed up because of this problem.

Release note

No response

Triage and priority

• Severity: S0 - Affects critical data or functionality and leaves users without workaround.
• Severity: S1 - Affects critical data or functionality and forces users to employ a workaround.
• Severity: S2 - Affects non-critical data or functionality and forces users to employ a workaround.
• Severity: S3 - Affects non-critical data or functionality and does not force users to employ a workaround.
• Severity: S4 - Affects aesthetics, professional look and feel, “quality” or “usability”.