topic Re: Line chart, cumulative, multiple lines in App Development

Line chart, cumulative, multiple lines

Anonymous — Fri, 02 Feb 2018 08:11:48 GMT

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.

Company	Transaction date	Transaktio_ distributed
Company x	1.1.2015	1
Company x	1.2.2015	1
Company x	1.3.2015	1
Company x	1.4.2015	1
Company y	1.1.2015	1
Company y	1.2.2015	1
Company y	1.3.2015	1
Company y	1.4.2015	1

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?

Re: Line chart, cumulative, multiple lines

Anonymous — Fri, 02 Feb 2018 08:46:16 GMT

Was able to figure it out

(Aggr(RangeSum(Above(Sum(Transaktio_capital_called), 0, RowNo())), Company, (Hvuosi, (Numeric))))

Re: Line chart, cumulative, multiple lines

TKi1 — Tue, 12 Nov 2019 08:58:31 GMT

Hi!

Thanks for sharing your solution!

I had a similar problem and after some fiddling, I got it to work.

I've prepared some toy data to illustrate my problem (just the first 10 lines are displayed):

Date	Customer	Sales
03.03.2019	a	23
05.08.2019	b	34
23.06.2019	a	45
01.01.2019	b	56
27.09.2019	a	12
09.12.2019	b	89
06.05.2019	a	45
12.02.2019	b	67
08.04.2019	a	23

To get the cumulative distribution I used (similar to Jarkkotesi's solution):

Aggr(RangeSum(Above(Sum(Sales), 0, RowNo())), (Date, (NUMERIC, ASCENDING)))

The resulting line chart looks like this:

Re: Line chart, cumulative, multiple lines

TKi1 — Fri, 15 Nov 2019 12:35:23 GMT

Hi!

Unfortunately there is a mistake in the expression from my last post which wasn't too obvious to me at first. I think I got it now. The expression should be:

Aggr(RangeSum(Above(Sum(Sales), 0, RowNo())), (Customer), (Date, (NUMERIC, ASCENDING)))

Sorry for the confusion!