Results not part of criteria display in chart

[#1]

Hi there,

I have a very simple doc (but due to time and data constraints I can't attach it) that has a very simple structure for reporting on an amount per customer.  One table has the customer ID, some other stuff and the amounts.  Another table has the customer information in it with the customer id.  Not all customers in the customer table have an amount record, some customers have multiple amount records.

When I add the fields I need to the chart and do a selection of date criteria that comes from the amount I get the data relevent to that date but then all of the rest of the data also comes through, but without any matching data?  Nulls in everything but the amount field and the amounts are from date ranges not selected?

There is no set analysis in this chart and every record in the amounts table has a customer ID.

If someone can suggest where I may have gone wrong with this it would be most appreciated.

Thanks,

Lorna

[Gysbert_Wassenaar]

Did you enable the option Show All Values for the Dimensions in your chart? If so, try unchecking that option.

[SunilChauhan · Accepted solution]

in dimension

click on booking preiod and check on

supress when value is null

hope this helps

[#4]

Thanks so much this seems to have resolved the issue that I have with the display of the chart.

I'm not sure I why understand this is necessary though.  There aren't any records with a null value for the booking period in my data so why is generating records like this that need to be suppressed?

[pover]

Lorna,

Could you please post a snapshot of the data model?

My first theory is that Month and Year are being generated from Booking Date or that Booking Date resides in a table that links to the amount field using a key field that doesn't consider the date.

Karl

[#6]

Thanks Karl.

Here is a picture of the data structure.

Month and Year are being generated from the booking Date and they all actually reside in the same table with the amounts.

[pover]

Nothing stands out as being wrong, but I would be careful to validate the data to make sure everything is ok.  What you are seeing with the null values can indicate a more serious problem in the model and enabling the option to hide null values is like sweeping dirt under the rug.

Karl

[#8]

Thanks for looking at it Karl. That's exactly what I was worried about so I'll continue to dig.  But hide in the meantime so I can move forward.  😉

Lorna