No link between dates

1) Check the joins between the tables.

2) The X-axis data in one is date-wise while the other is month-wise[Year is not discrete].

3) Try creating a separate date table, join both the tables' date columns to the date table, and use that for the x-axis.

Hi Anonymous 

ChiragGarg2512 Thank you very much for your prompt reply. Creating a separate date sheet is very much the right thing to do.

Here I have provided another idea, again related to creating a table relationship.

If you are not considering creating a separate date table, then try creating a relationship based on the date columns of both tables.

Here's some dummy data

“nature”

“shipment”

Create table relationships by dragging and dropping in the model view.

Here is the result.

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.