Scatter Graph with Average calculations & Multiple fields
Hi QV Community,
I am trying to create a scatter graph based on multiple fields of data, with comparisons on 2 sets of averages ranging between 0-10. Its based on a survey, requesting Importance score vs Satisfaction score across several different areas. Data is pulled from Excel as follows:
Respondent
Imp A
Sat A
Imp B
Sat B
Imp C
Sat C
1
5
3
3
8
8
8
2
8
5
5
3
4
6
3
4
8
8
8
4
4
4
9
9
4
4
2
3
5
3
2
6
7
5
5
6
7
5
6
4
1
3
7
0
7
8
9
3
2
8
7
5
9
4
5
5
9
2
9
3
7
4
4
10
5
4
10
4
2
6
I am looking to plot axis X as Satisfaction, Y as Importance, with the averages as the score. Is this possible in QV? What would the expressions/dimensions be?
