[GH-ISSUE #6547] [Bug]: Reports from similarly named categories show wrong sums #51892

Closed
opened 2026-04-30 19:44:52 -05:00 by GiteaMirror · 2 comments
Owner

Originally created by @annnnnetens on GitHub (Jan 4, 2026).
Original GitHub issue: https://github.com/actualbudget/actual/issues/6547

Verified issue does not already exist?

  • I have searched and found no existing issue

What happened?

I have two categories named "Food", one in group "Usual expenses" and one in group "Vacation". When creating a line graph report containing the Usual expenses food, it shows as zero every week, even though clicking on a node shows existing nonzero transactions.

Image Image

Interestingly, when adding both Food categories, both of the graphs match the latter Vacation Food category, which shows up correctly.
Image

Renaming Vacation Food to Food1 fixes the graphs and they behave as expected, and renaming it back to Food breaks it again.

Image

How can we reproduce the issue?

Create two categories with the same name in different groups, and create a weekly line graph with only one of the categories.

Where are you hosting Actual?

Docker

What browsers are you seeing the problem on?

Safari

Operating System

Mac OSX

Originally created by @annnnnetens on GitHub (Jan 4, 2026). Original GitHub issue: https://github.com/actualbudget/actual/issues/6547 ### Verified issue does not already exist? - [x] I have searched and found no existing issue ### What happened? I have two categories named "Food", one in group "Usual expenses" and one in group "Vacation". When creating a line graph report containing the Usual expenses food, it shows as zero every week, even though clicking on a node shows existing nonzero transactions. <img width="774" height="761" alt="Image" src="https://github.com/user-attachments/assets/83245014-ede2-4da2-b9c5-7bc8af701726" /> <img width="1266" height="389" alt="Image" src="https://github.com/user-attachments/assets/3cb7df72-391a-4616-9cde-d14943cb0cda" /> Interestingly, when adding both Food categories, both of the graphs match the latter Vacation Food category, which shows up correctly. <img width="767" height="746" alt="Image" src="https://github.com/user-attachments/assets/62f2692c-737f-4902-bf5f-5465701fa795" /> Renaming Vacation Food to Food1 fixes the graphs and they behave as expected, and renaming it back to Food breaks it again. <img width="699" height="658" alt="Image" src="https://github.com/user-attachments/assets/04545202-fe68-41ce-9db5-096778eef01e" /> ### How can we reproduce the issue? Create two categories with the same name in different groups, and create a weekly line graph with only one of the categories. ### Where are you hosting Actual? Docker ### What browsers are you seeing the problem on? Safari ### Operating System Mac OSX
GiteaMirror added the reportsgood first issuebug labels 2026-04-30 19:44:53 -05:00
Author
Owner

@youngcw commented on GitHub (Jan 6, 2026):

likely related to #3476

<!-- gh-comment-id:3715232127 --> @youngcw commented on GitHub (Jan 6, 2026): likely related to #3476
Author
Owner

@Faizanq commented on GitHub (Jan 7, 2026):

I'd like to work on this issue. I'll investigate the related issue #3476 and look into how the reports are aggregating categories by name instead of by unique ID.

<!-- gh-comment-id:3718097993 --> @Faizanq commented on GitHub (Jan 7, 2026): I'd like to work on this issue. I'll investigate the related issue #3476 and look into how the reports are aggregating categories by name instead of by unique ID.
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/actual#51892