Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

CREATE A TABLE - challenge

Hi! I have 3 tables (Datasets) as the ones on the top (A, B and C). And I created a Visualization Table in PBA as the one on the left corner.  How can I create the orange Visualization Table neede...
Need Help
  • barritown's avatar
    barritown
    3 years ago

    Hi Anonymous,

    You have a problem in your data. I assume you have built your VISUALIZATION TABLE using the many-to-many relationship between the Table A and Table B. But if you take a close look at Shelly from Marketing in the Table A, you will see that there are two entries in the Table B which can be applied to her: Manager-Marketing and Relationships-Marketing.

    You can close your eyes, ignore this duality and solve your case with the crazy measure below, but I won't recommend doing that - it would be better to double check your data model.

     

    Best Regards,

    Alexander

    My YouTube vlog in English

    My YouTube vlog in Russian

     

barritown's avatar
barritown
Solution Sage
3 years ago

Hi Anonymous,

You have a problem in your data. I assume you have built your VISUALIZATION TABLE using the many-to-many relationship between the Table A and Table B. But if you take a close look at Shelly from Marketing in the Table A, you will see that there are two entries in the Table B which can be applied to her: Manager-Marketing and Relationships-Marketing.

You can close your eyes, ignore this duality and solve your case with the crazy measure below, but I won't recommend doing that - it would be better to double check your data model.

 

Best Regards,

Alexander

My YouTube vlog in English

My YouTube vlog in Russian