Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a scatter chart where I have plotted Product IDs. However, when you hover over the points, I would like to have the Product Description display, rather than the Product IDs. I have to plot IDs over Descriptions because the relationship is not 1-1.
Any ideas on how to do this?
Thank you,
Mel
Hi,
another solution could be a calculated dimension that generates dual values (Product ID (if numerical) formated as Product description):
=Dual([Product Description],[Product ID])
Using the Product description directly as the first dimension would require it to e unique like the Procuct ID.
Otherwise the bubble count and positions could change.
hope this helps
regards
Marco
You can try adding another expression " ='Product Description : ' & [Product Description] " and tick Text as Pop-up
Keep in mind, the third expression dictates the bubble size, so you would want to add it after that
You can also add Product Description as first Dimension
Hi,
another solution could be a calculated dimension that generates dual values (Product ID (if numerical) formated as Product description):
=Dual([Product Description],[Product ID])
Using the Product description directly as the first dimension would require it to e unique like the Procuct ID.
Otherwise the bubble count and positions could change.
hope this helps
regards
Marco