2 Replies Latest reply: Nov 29, 2017 11:26 AM by RAVI SHINGE RSS

    Cumulative Line Chart

    RAVI SHINGE

      Hello Guys,

       

      I need to plot Number of Hours vs No months In a Line chart . I wanted to show a nice cumulative curve .Could you  please help me with this . My sample data is shown as below though there are lot of values I am just showing few .

       

      HoursMonths
      2001
      6002
      10003
      15004

       

      My months expression is :- (If(( Flow='3'),Round((((( fabs(If (''LOI''<0,(''LOI''))*Hours)/Days)))/730.0008),0.01),Null() ))

      My months expression works fine .

       

      SO kindly help me how do I plot cumulative line chart.

      Thanks,

      ravi

        • Re: Cumulative Line Chart
          Felip Drechsler

          Hi Ravi,

           

          What you want to achieve you could do with RangeSum.

          I've made a A simple sample app with your data with the following expression:

          rangesum(above( sum(REVENUE), 0, rowno() ))

          wich gives the cumulative \aspect your searching for.

           

          Attached the app I made, hope it helps.

           

          Felipe.

            • Re: Cumulative Line Chart
              RAVI SHINGE

              Hello Felipe,

              Thanks a lot for replying !

               

              Yes it worked to some extent .

              Now I have data something like this as show below in the image where you can see there are multiple

              Flow Number 4 and 1 and which has multiple values assigned. So in this case I am not able to get curve . So how do I handle this ?

               

              Flow3 field is my dimension

              and the big expression is my Measure .

              Kindly help me with this .....

              790cb5d654ee4813b9288cc3f284a1cb.png