Forum Discussion

CCE_Dave's avatar
CCE_Dave
Frequent Visitor
3 years ago
Solved

Show customers without sales entry

Hello,   I need your help in a table visual. I want to show all customers with their sales for the last past two years. As a base I use a customer database and a sales history. In the modell are al...
Need Help
  • CCE_Dave's avatar
    CCE_Dave
    3 years ago

    Hi guys,


    Thank you for your help! In the meantime, I have discovered the error. You were right, the error was in the data model. The connection between my customer data, the history data and a help table with different countries/markets was incorrect. The table with my countries/markets had a wrong connection to my customer data. 

     

    That was the reason why "Show item without data" didn't work and showed me a customer with all available countries. ^^"

     

    Thanks, the topic can be closed.

CCE_Dave's avatar
CCE_Dave
Frequent Visitor
3 years ago

Hi guys,


Thank you for your help! In the meantime, I have discovered the error. You were right, the error was in the data model. The connection between my customer data, the history data and a help table with different countries/markets was incorrect. The table with my countries/markets had a wrong connection to my customer data. 

 

That was the reason why "Show item without data" didn't work and showed me a customer with all available countries. ^^"

 

Thanks, the topic can be closed.