Data not coming in chart ?

[suvechha_b]

Hi All ,

Sample model attached.

I have data for distributor 'PIN' for product 1205 but its not pulling in distributor-link . ref - see the diagram.

The distributor link chart is not showing data.

[sunny_talwar · Accepted solution]

You are using 0 as your expression... I guess try with 1 or uncheck 'Suppress Zero Value' on the presentation tab

Is this what you are hoping to see?

[kaushiknsolanki]

Hi,

It is because your Sql Query is not fetching the data from source system for for distributor ISH.

Also you have a synthetic table in your data model, kindly have a look at below link to know to avoid them.

What is synthetic keys? How it can be avoided?

Regards,

Kaushik Solanki