undefined

[bektasb]

Hello everyone, 

I have the following problem  here.

Total number is 52,000.

In 2021 it will be 932.

When I go into quarter I have a bar (Empty) here there are 44000 pieces at

Q1 248,Q2 223, Q 3198, Q4 263 Q=quarter)

How can it be that 44,000 pieces are shown to me as empty.

Why doesn't he take this in Q1,Q2,Q3 or

Q4?

whats wrong here?

What data is missing that it shows me empty?

[jpessoa8 · Accepted solution]

Hi @bektasb,

Without the dataset it's hard to indentify the information that is missing but, from looking at the that graph, i would say you are using a "Date" table and a "Factual Table" and have a relationship between them with a field like Date correct?

I would imagine that the (empty) column is showing because you are using a field from the "Date" Table and there are records in the "Factual Table" that don't have a match with that table.

My suggestion is converting that graph in to a matrix, have in there both the columns that are used in the relationship between the "Date" table and the "Factual Table" and also that Durchschnitt measure and you will be able to see what values from the "Factual Table" are as (empty) for the "Date" table.

It could be something as simple as having a date format on oneside of the relationship and a datetime format on the otherside.

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudo 👍
Thanks!

You can also check out my LinkedIn!

Best regards,
Jorge Pessoa