0 Replies Latest reply: Feb 28, 2013 10:02 AM by Joe Berryman RSS

    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:

       

      RespondentImp ASat AImp BSat BImp CSat C
      1533888
      2855346
      3488844
      4994423
      5326755
      6756413
      7078932
      8759455
      9293744
      105410426

       

      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?

       

      Cheers