2 Replies Latest reply: May 17, 2011 9:56 AM by Chris Cammers RSS

    Compass in radar chart

      Hi all

       

      I would like to make a radar chart in which I would to display the electricity production of wind turbine per wind direction.

       

      I believe the radar chart is the best option for that: I'll apply the class function to my wind direction variable, and plot my production against this.

       

      Two issues though (see images below:

      - Image 1: the data point for 0-30 degree range is on top, whereas I would like it to where the 30-60 degree point is now.

      - Image 2: if I filter on one given day in the year, the wind does not do a full 360 tour during that day, so I see only those point where the wind has actually come from that day. Apparently, setting the dimension axis scale does not solve this.

       

      Any thoughts on how to resolve this?

       

      Image 1

      compass1.JPG

       

      Image 2

      compass2.JPG

        • Compass in radar chart
          Patrick Laredo

          hi,

           

          one way of doing it could be as follows:

           

          building a Master Wind Direction table to which you connect your wind variable.

           

          Create it in your script by doing something like the following:

           

          masterWindDirectiontmp:

          load distinct WindDirection  // thislinks to your table with production and wind dircetion

          resident PreviouslyLoadedProductionData;

           

          masterWindDirection:

          load WindDirection, 

                 put your class function here  as WindDirectionGroup // this creates your 12 groups you want on the radar chart

          resident masterWindDirectiontmp;

           

          drop table

          masterWindDirectiontmp;

           

          now you attach to the previos table a 12 row table which gives you the sorting you are looking for

          This table would have its 12 rows as you achieved with using your class function, make sure the WindDirectionGroup has the sames names and they will link up

           

          masterWindDirectionSortOrder:

          load * inline

          [

          WindDirectionGroup, WindDirectionGroupSortOrder

          330 t 360, 1

          0 to 30, 2

          etc

          etc.

          ];

           

          Now in your radar chart use the WindDirectionGroup field as dimension, sum the production from your initial table, on the sort tab select "Expression" and then select the  WindDirectionGroupSortOrder in th expression box, on the presentation tab make sure "Supress ZERo-values" and " suppress missing" are not ticked.

           

          hope this helps

            • Compass in radar chart
              Chris Cammers

              I know your requirement is to produce a radar chart but I think the intention behind the chart is to compare production at the different points on the compas. I agree that it is logical to display it as a radar but I can't help but feel that a bar chart would be better to compare the quantity at each direction.

               

              Realizing what effect you are trying to achieve I have to wonder what would happen to your radar chart if the user were to filter out directions greater than 180, the radar chart would still display a circle but you'd have only half a circle worth of compass points.

               

              Just some things to think about from a vizualization perspective.

               

               

              Thanks

               

              Chris