1 Reply Latest reply: Apr 7, 2016 5:05 AM by Stefan Wühl RSS

    Graph with the number of voting...

    Graziano Grasso

      Goodmorning everyone,
      I have the following table :

             

      YEARQUAD.ClassSez.ESItaStoGeo
      15/15I1AA888
      15/16I1AA777
      15/16I1AA777
      15/16I1AA888
      15/16I1AA999
      15/16I1AA666
      15/16I1AA666
      15/16I1AA777
      15/16I1AA666
      15/16I1AA888
      15/16I1AA777

       

      how can I get something like :

        

      Disciplina1098765
      Ita013430
      Sto013430
      Geo013430

       

      thank you

        • Re: Graph with the number of voting...
          Stefan Wühl

          Maybe like this

           

          In your LOAD script:

           

          CROSSTABLE (Disciplina, Vote, 5)

          LOAD YEAR, QUAD, Class, [Sez.], ES, Ita, Sto, Geo

          FROM YourTable;

           

          LOAD 4+Recno() as Vote

          Autogenerate 6;

           

          Then create a pivot table chart, two dimensions, Disciplina and Vote and one expression

          =Count(Vote)

           

          Pivot Disciplina to the top.

           

          And disable 'suppress zero values' on presentation tab.