Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have some data that I want to display in scatter chart.
I have 2 dimensions
- dimension1 - this is each record in the table - say unique id for each row. So the number of dots should be equal to number of records.
- dimension1 - this is each record in the table - say unique id for each row. So the number of dots should be equal to number of records.
- dimension2 - this is a combination of 2 columns. tp and vc. Colors of each dot is based on these 2 columns
tp vc
a 1
b 2
c 1
So there will be dots of 3 colors based on the above tp and vc combinations
Then there are 3 expressions representing X and Y and Size of dot
I am not sure how to configure the dimensions to achieve the goal.
Thanks
Can you post a example with sample data?
ID tp vc yi ye q
1 m v1 10 1.2 10
2 cm v2 21 2.5 20
3 m v1 8 1.0 10
4 cm v2 12 3.5 40
5 mm v3 14 4.0 10
So ID represents each dot, tp and vc together represent color, if there are 5 unique combonations then dots will be of 5 colors. ye is X, yi is Y and q is Z
Hope that helps
see attached qvw
Thanks for your help Gysbert, I think this works for me, have to test with my data.