1 Reply Latest reply: Feb 2, 2018 3:46 AM by Jarkko Pelli RSS

    Line chart, cumulative, multiple lines

    Jarkko Pelli

      Hi Community,

      Im trying to display  cumulative value based on date for multiple companies in a line chart. Basically the idea is to display a cumulative line for each selected company, ie.  If I select 2 companies, it should draw a 2 lines, one for each company.


      Heres what ive have done:


      I have a table that has 3 columns.


      CompanyTransaction dateTransaktio_ distributed
      Company x1.1.20151
      Company x1.2.20151
      Company x1.3.20151
      Company x1.4.20151
      Company y1.1.20151
      Company y1.2.20151
      Company y1.3.20151
      Company y1.4.20151


      What Im doing, is displaying a linechart with Company and Transaction date as dimensions, and the following expression as a measure:  rangesum( above( total sum(Transaktio_distributed),0,1000)).

      If I select only Company x, the data is correctly displayed. If I select both companies, the numbers get all messed up. 

      What formula do I need to use for Transaction distributed for this to work?