Forum Discussion
One Line Chart, 2 Tables
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
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
1 Reply
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