Forum Discussion
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 when go to data tab and make filter by sales man it's appeard 153
knowing i use the
my quastion why there are deffirencts ?
Relation between tablesnumber of customers in data tabnumber of customers in visualization chart
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.
2 Replies
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.Thank you very much , i fixed the relation and change the relation ,
