Issue : Incorrect Data on Magento 2 Dashboard

[nylanBCM]

Preconditions and environment

• Magento 2 ver. 2.4.5-p3
• Go to the dashboard section

Steps to reproduce

1. Log in to the Magento 2 admin dashboard.
2. Navigate to the dashboard section where sales data is displayed.
3. Observe the details beside the graph/chart.
4. The dashboard of my Magento 2 store is displaying incorrect data.
5. While the graph/chart shows previous sales, the day, and the time correctly, the detailed information beside the graph is nonsensical and unrelated to the actual sales data.

Expected result

The dashboard should accurately display, regarding of the actual sales :

1. Daily revenue
2. Tax
3. Shipping fees
4. Quantity of orders

Actual result

The details beside the sales graph/chart are incorrect and do not reflect the actual sales data. And I don't understand how they even calculate the revenue below the graph.

Additional information

No response

Release note

Could you please provide guidance or a fix to configure the dashboard to accurately display:

1. Daily revenue
2. Tax
3. Shipping fees
4. Quantity of orders

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.
• [X] 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”.

[m2-assistant[bot]]

Hi @nylanBCM. Thank you for your report. To speed up processing of this issue, make sure that the issue is reproducible on the vanilla Magento instance following Steps to reproduce. To deploy vanilla Magento instance on our environment, Add a comment to the issue:

• @magento give me 2.4-develop instance - upcoming 2.4.x release
• For more details, review the Magento Contributor Assistant documentation.
• Add a comment to assign the issue: @magento I am working on this

• To learn more about issue processing workflow, refer to the Code Contributions.

  Join Magento Community Engineering Slack and ask your questions in #github channel. :warning: According to the Magento Contribution requirements, all issues must go through the Community Contributions Triage process. Community Contributions Triage is a public meeting. :clock10: You can find the schedule on the Magento Community Calendar page. :telephone_receiver: The triage of issues happens in the queue order. If you want to speed up the delivery of your contribution, join the Community Contributions Triage session to discuss the appropriate ticket.

[m2-assistant[bot]]

Hi @engcom-Bravo. Thank you for working on this issue. In order to make sure that issue has enough information and ready for development, please read and check the following instruction: :point_down:

• [ ] 1. Verify that issue has all the required information. (Preconditions, Steps to reproduce, Expected result, Actual result).
• [ ] 2. Verify that issue has a meaningful description and provides enough information to reproduce the issue.
• [ ] 3. Add Area: XXXXX label to the ticket, indicating the functional areas it may be related to.
• [ ] 4. Verify that the issue is reproducible on 2.4-develop branch
  Details

  - Add the comment @magento give me 2.4-develop instance to deploy test instance on Magento infrastructure.
  - If the issue is reproducible on 2.4-develop branch, please, add the label Reproduced on 2.4.x.
  - If the issue is not reproducible, add your comment that issue is not reproducible and close the issue and stop verification process here!
• [ ] 5. Add label Issue: Confirmed once verification is complete.
• [ ] 6. Make sure that automatic system confirms that report has been added to the backlog.

[m2-assistant[bot]]

Hi @engcom-Dash. Thank you for working on this issue. In order to make sure that issue has enough information and ready for development, please read and check the following instruction: :point_down:

• 1. Verify that issue has all the required information. (Preconditions, Steps to reproduce, Expected result, Actual result).
• 2. Verify that issue has a meaningful description and provides enough information to reproduce the issue.
• 3. Add Area: XXXXX label to the ticket, indicating the functional areas it may be related to.
• 4. Verify that the issue is reproducible on 2.4-develop branch
     Details

     - Add the comment @magento give me 2.4-develop instance to deploy test instance on Magento infrastructure.
     - If the issue is reproducible on 2.4-develop branch, please, add the label Reproduced on 2.4.x.
     - If the issue is not reproducible, add your comment that issue is not reproducible and close the issue and stop verification process here!

---

• Join Magento Community Engineering Slack and ask your questions in #github channel.

[engcom-Dash]

@magento give me 2.4-develop instance

[magento-deployment-service[bot]]

Hi @engcom-Dash. Thank you for your request. I'm working on Magento instance for you.

[magento-deployment-service[bot]]

Hi @engcom-Dash, here is your Magento Instance: https://e48abcf4d783d04fe071a0fc8731cf54.instances-prod.magento-community.engineering Admin access: https://e48abcf4d783d04fe071a0fc8731cf54.instances-prod.magento-community.engineering/admin_503e Login: ebea56ae Password: 08c2102227b3

[engcom-Dash]

Hi @nylanBCM

Thanks for reporting and collaboration.

Verified the issue on Magento 2.4 dev instance but the issue is not reproducible.

We are able to see the correct data on Magento 2 Dashboard

Steps to reproduce :

1. Log in to the Magento 2 admin dashboard.
2. Navigate to the dashboard section where sales data is displayed.
3. Observe the details beside the graph/chart.
4. The dashboard of my Magento 2 store is displaying incorrect data.
5. While the graph/chart shows previous sales, the day, and the time correctly, the detailed information beside the graph is nonsensical and unrelated to the actual sales data.

Please refer the attached screenshots.

Previous data:

Date after new order is placed and order status is completed.

[nylanBCM]

Hi Susanna,

Thanks for your prompt response and for verifying the issue on the Magento 2.4 dev instance.

I appreciate your detailed steps to reproduce the issue. However, the problem we are encountering seems to persist on our end. Here's a summary of what we have observed:

1. Discrepancy in Sales Data for June 21 represented on the dashboard’s graph:

   • After a detailed review of the sales data, there appears to be a discrepancy of approximately $1800.09 - $1161.75 = $638.34 that is not reflected in the graph for this day.

   • This discrepancy is observed in the total sales amount displayed on the graph compared to the detailed sales report for that day.

2. Sales Calculation Adjustment Request :

   • Additionally, I would like to request an adjustment in how the revenue below the graph in orange is calculated.

   • Instead of a rolling 24-hour total, we need the sales to be calculated for the total of the day starting at 12:00 PM to be shown as “Revenue” below the graph.

To help with troubleshooting, I have attached screenshots of our dashboard illustrating the discrepancies observed:

• “Dashboard – Graph” -> go to magento -> dashboard -> look at the graph and the columns of today’s sales in the amount section of the graph.

• “Sales – Order’ -> Go to magento -> Sales -> Orders -> Calculate the amount of sales of the day.

Please let me know if you need any additional information or if there are specific steps we can take on our end to further diagnose the issue.

Thank you for your assistance. You can call me at 0423924921.

Best regards,

Nylan

From: susena sravani simhambhatla @.> Sent: Thursday, 20 June 2024 6:08 PM To: magento/magento2 @.> Cc: nylanBCM @.>; Mention @.> Subject: Re: [magento/magento2] Issue : Incorrect Data on Magento 2 Dashboard (Issue #38841)

Hi @nylanBCM https://github.com/nylanBCM

Thanks for reporting and collaboration.

Verified the issue on Magento 2.4 dev instance but the issue is not reproducible.

We are able to see the correct data on Magento 2 Dashboard

Steps to reproduce :

1. Log in to the Magento 2 admin dashboard.
2. Navigate to the dashboard section where sales data is displayed.
3. Observe the details beside the graph/chart.
4. The dashboard of my Magento 2 store is displaying incorrect data.
5. While the graph/chart shows previous sales, the day, and the time correctly, the detailed information beside the graph is nonsensical and unrelated to the actual sales data.

Please refer the attached screenshots.

Previous data:

38841_1.png (view on web) https://github.com/magento/magento2/assets/60198592/5f9a26c3-13d2-4db5-b33d-f8e028e3bd87 38841_2.png (view on web) https://github.com/magento/magento2/assets/60198592/8ff56342-83d7-48ab-9e62-4e6b33ad0da0

Date after new order is placed and order status is completed.

38841_3.png (view on web) https://github.com/magento/magento2/assets/60198592/51e7f7d7-43fc-4893-b08d-fff396351053

— Reply to this email directly, https://github.com/magento/magento2/issues/38841#issuecomment-2180070660 view it on GitHub, or https://github.com/notifications/unsubscribe-auth/BJJTKWOURWK2D6E7EMTUEMDZIKEV7AVCNFSM6AAAAABJRJWS56VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDCOBQGA3TANRWGA unsubscribe. You are receiving this because you were mentioned. https://github.com/notifications/beacon/BJJTKWLVH67ECSUNBTHHKZDZIKEV7A5CNFSM6AAAAABJRJWS56WGG33NNVSW45C7OR4XAZNMJFZXG5LFINXW23LFNZ2KUY3PNVWWK3TUL5UWJTUB6E6QI.gif Message ID: < @.> @.>

[nylanBCM]

I'm encountering an issue with the revenue calculation on my Magento 2.4.5-p3 dashboard. The displayed revenue for "today" does not accurately reflect sales from 12 AM to the current time, instead using an incorrect period, resulting in inaccurate daily revenue reporting. I've confirmed the timezone and locale settings are correct, but the problem persists. Could anyone advise on how to modify the code to ensure the correct time range is used for daily revenue calculations, or suggest any solutions or extensions that might help?

[engcom-Dash]

@magento give me 2.4-develop instance

[magento-deployment-service[bot]]

Hi @engcom-Dash. Thank you for your request. I'm working on Magento instance for you.

[magento-deployment-service[bot]]

Hi @engcom-Dash, here is your Magento Instance: https://e48abcf4d783d04fe071a0fc8731cf54.instances-prod.magento-community.engineering Admin access: https://e48abcf4d783d04fe071a0fc8731cf54.instances-prod.magento-community.engineering/admin_3943 Login: c14c10de Password: 42321bfa6231

[m2-assistant[bot]]

Hi @engcom-Delta. Thank you for working on this issue. In order to make sure that issue has enough information and ready for development, please read and check the following instruction: :point_down:

• [ ] 1. Verify that issue has all the required information. (Preconditions, Steps to reproduce, Expected result, Actual result).
• [ ] 2. Verify that issue has a meaningful description and provides enough information to reproduce the issue.
• [ ] 3. Add Area: XXXXX label to the ticket, indicating the functional areas it may be related to.
• [ ] 4. Verify that the issue is reproducible on 2.4-develop branch
  Details

  - Add the comment @magento give me 2.4-develop instance to deploy test instance on Magento infrastructure.
  - If the issue is reproducible on 2.4-develop branch, please, add the label Reproduced on 2.4.x.
  - If the issue is not reproducible, add your comment that issue is not reproducible and close the issue and stop verification process here!
• [ ] 5. Add label Issue: Confirmed once verification is complete.
• [ ] 6. Make sure that automatic system confirms that report has been added to the backlog.

[engcom-Bravo]

Hi @nylanBCM,

Thanks for your update.

We have verified the issue in Latest 2.4-develop instance and the issue is not reproducible.It is recommended to verify the issues in Latest 2.4-develop instance.Hence we are closing the issue.

Thanks.