5 Replies Latest reply: May 15, 2014 10:01 AM by gico1972 _ RSS

    Summary of percentages

    gico1972 _

      I am a novice using Monarch V8 however i have for days now struggled to achieve something that i am sure is very simple.

       

      Need to summarise table data so that i get performance of flight inventory sold for the whole period and not by specific date.

       

      The following shows original data in my table and how i want Monarch to calculate % of sold per flight number over whole period.

       

      Appreciate any help you can give on this as i am becoming frustrated on how to set up the Key/Item/Measure fields when setting up the summary.

       

      Fields are

       

      D          Date

      F          Flight Number

      C          Capacity

      S          Sold

      A          Available

      %         Percentage Sold

       

      Thanks

       

      Table     /B                    

       

         D          F           C           S          A            %

      10-Jun     222     200     123     77     61.50%

      10-Jun     333     250     132     118     52.80%

      11-Jun     111     200     144     56     72.00%

      11-Jun     222     200     99     101     49.50%

      11-Jun     333     200     132     68     66.00%

      12-Jun     111     250     152     98     60.80%

      13-Jun     111     200     143     57     71.50%

      13-Jun     222     200     121     79     60.50%

      14-Jun     111     250     122     128     48.80%

      14-Jun     222     200     143     57     71.50%

      14-Jun     333     200     167     33     83.50%

      15-Jun     111     250     188     62     75.20%

                                

      Summary     /B                    

           F         C          S           A         %[/B]

           111     1150     749     401     65.13%

           222     800     486     314     60.75%

           333     650     431     219     66.31%

        • Summary of percentages
          Olly Bond

          Hi Gico,

           

          If you define a summary with Flight as the key field, then select as measures:

           

          Sum(Capacity)

          Sum(Sold)

          Sum(Available)

          count()

           

          Double click on the count() measure and edit the calculation tab to:

           

          Type: Other

           

          Then SUM(Sold)/SUM(Capacity) in the formula should give you meaningful results.

           

          There's a Monarch training course in London in June - further information on www.datawatch-europe.com[/url], or from the team on 01752 893 100, or by dropping me a mail.

           

          Best wishes,

           

          Olly