Radar plot - Comparison

[ylbp]

Hi everyone,

I created a radar plot with the dataset that is shown in the picture below. When I compare product 1 and 2, I don’t want the attribute 2 to show up in the radar plot because the intensity of that attribute is zero for both products. For that specific comparison, I want the radar plot to show only the attributes where at least one of the products have an attribute’s intensity higher than zero. Is there a way to do that?

P.S. I want to keep all the dots connected and want the visual to reflect when the intensity of an attribute is a true zero. Otherwise, if the dots are not connected or there is not a value assigned to an attribute, the audience looking at this report won't know if that attribute was not tested or if they can assume that is a zero. I hope this makes sense. I would be happy to provide more clarification if needed. 

Thanks!

[Anonymous]

Hi @ylbp ,

Please share the data in text format so that we could use it.

Best Regards,

Jay

[ylbp]

Thanks for the suggestion @Anonymous. See the data below:

Product	Intensity	Attribute
Product 1	3.0	Attribute 1
Product 1	0.0	Attribute 2
Product 1	2.0	Attribute 3
Product 1	2.0	Attribute 4
Product 1	2.5	Attribute 5
Product 2	6.0	Attribute 1
Product 2	0.0	Attribute 2
Product 2	2.5	Attribute 3
Product 2	0.0	Attribute 4
Product 2	2.0	Attribute 5
Product 3	3.2	Attribute 1
Product 3	3.0	Attribute 2
Product 3	2.3	Attribute 3
Product 3	2.2	Attribute 4
Product 3	3.6	Attribute 5