Skip to main content

Hello, experts,

 

Another interesting case and a problem occurred that i didn't take into consideration when i recommended to the client the specific visualization. see attached the workbook.

 

So what we have are two similar graphs (bubble charts, i'm using circles and distinct count on textID), so both graphs compares "Brand5" on the left with any choosen brand on the right, applying the following filters: Market, Levels, Position.

The issue is that i do not have axis in order to sync it between the graphs and for example bubble on the left with count of 1 is with the exact same size with the bubble on the right with countd textID of 4 (e.g. Overall Satisfaction > USA > Level2 > Position1 > Brand2 on the right graph).

 

Changing the viz is not acceptable at this time, given that the client really like it, but still how to proceed in order to sync the sizes from left and right graphs in order to be same and be able to compare each other visually, not only comparing the info within the tooltip?

 

Kind Regards,

P

3 answers
0/9000