Data is coming wrong or data model is wrong

[Anonymous]

Hi All,

When i am creating data modelling i got difficulties to link  3 table with composite key and i think my linking is not proper.

can you please check and validate.

When i am creating reports month is not coming.

PFA

[Anonymous]

PFA

[danieloberbilli]

You have to reconsider your keys:

Your table Sample Calls Dump is linked by Agency & Date to Sample Dump File

Your chart expression limits the data to {<Status={'Lost ACD'}>}

As you see in the tables: there are only two cases: both at the 28/03/2015

BUT: in your linked table (that is between your first and the calendar table) there is no date 28/03/2015 - not for Agency 1, nor for any other...so there is no linkage to your calendar.