Forum Discussion

Raed's avatar
Raed
New Member
3 years ago
Solved

Result in Visualization is not same in Data source

I tried to build one report to show the number of customers in Journy Plan for each sales man , but when i tried to make Count Function the result in visulisation chart appeared 135 customers and whe...
Interesting Links
Need Help
Show and Tell
  • Migasuke's avatar
    Migasuke
    3 years ago

    Hi Raed ,

    I do not see in your model JPCustomer[CustomerNo] but I have an idea where the problem is.
    You use some many:many bi-directional relationships. This kinda relationship causes problems in many cases.

    Maybe try to remove the relationships and then do the count for JPCustomer[CustomerNo]. If the number is OK, then add the relationships back and watch if the number is changed.



Migasuke's avatar
Migasuke
Memorable Member
3 years ago

Hi Raed ,

I do not see in your model JPCustomer[CustomerNo] but I have an idea where the problem is.
You use some many:many bi-directional relationships. This kinda relationship causes problems in many cases.

Maybe try to remove the relationships and then do the count for JPCustomer[CustomerNo]. If the number is OK, then add the relationships back and watch if the number is changed.