One Line Chart, 2 Tables

[e175429]

Ok, idk HOW I'm doing this wrong.

Hey All,

I have 2 tables, one form 2023, one from 2024.

Both tables are joined on a 1:1 relationship.

Seperately, their lines charts look like so:

2023

2024

When I try to graph their lines on the same chart, I get this:

It only shows 2023. Neither column is summarized.

IDK if it matters (i don't think it should) but the ID totals on each graph is different. for 2023, ID total 249. 2024 ID total is 393

[quantumudit · Accepted solution]

Hello @e175429 

The problem likely stems from inadequate data modelling. To better comprehend your needs, please provide a sample dataset along with any supplementary details, such as the relationships between tables, ID columns, etc.

Additionally, the 1-to-1 relationship depicted in the screenshot you provided appears to be unnecessary.

Best Regards,
Udit

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudo 👍

🚀 Let's Connect: LinkedIn || YouTube || Medium || GitHub
✨ Visit My Linktree: LinkTree