3 Replies Latest reply: Jan 11, 2012 4:04 AM by Roland Kunle RSS

    ordering categories in a graph

      Hi....

      does anyone know how I can give a personalized order to columns in a chart?

      I found only other ordering criteria such as alphabetic order, numbers....

      In this case I need to order the second dimension of a chart.

      the order should be "rete"-"prodotto"-"servizi"-"marchio"...

       

      Any idea?

      Thank you very much in advance for your help!

       

      Bye

      Silvia

        • Re: ordering categories in a graph

          Hi Silvia,

          if you got a individuel sort order for a field, you can create an additional table containing the according field and a order-field to use it for sorting in your charts.

          Check out the second chart in my little example app. The Column Name is sorted by expression --> Field Sortorder

           

          HtH

          Roland

            • Re: ordering categories in a graph

              unfortunately with the free edition I cannot open the file you attached to your message....

              anyway, I try to follow your instructions.

               

              Thank you so much!

              Bye Silvia

                • Re: ordering categories in a graph

                  Hi again,

                   

                  here is the load-script snippet.

                   

                  DimTable:

                  LOAD * Inline [

                  Name, Prename, Val

                  marchio, Reste, 100

                  rete, Alfonso, 200

                  prodotto, Amalia, 300

                  servizi, Guiseppe, 400

                  ];

                   

                   

                  SortTable:

                  LOAD * Inline [

                  Name, SortOrder

                  rete, 1

                  prodotto,2

                  servizi,3

                  marchio,4

                  ];

                   

                   

                   

                   

                  After loading build for ex. a straight table chart with Dims = Name and Prename and

                  a simple expression like sum(Val).

                  In sort tab check "Sort  By Expression" for Name and put in "SortOrder" into expression editor.

                   

                  If you got problems with it, post your app. People with an fully licenced version can open it 

                   

                  RR