topic Re: Line Graph Accumulation in App Development

Line Graph Accumulation

johnnyjohn — Mon, 27 Oct 2025 17:22:07 GMT

Apologies for earlier post, I've managed to distill down the issue significantly.

As you can see in the data table below, using this expression below, I've managed to calculate the cumulative sum of the n5_value_EUR relative to the n0_marketcap_group - so both market caps add up to 1 at the end of their respective clock (up to 1).

So this works in the table viz.

RangeSum(Above( Sum(n5_value_EUR), 0, RowNo())) / Sum( TOTAL <n0_marketcap_group> n5_value_EUR )

Trying to put this same measure in a line chart, it breaks, and doesnt actually accumulate across the dimensions.

Any thoughts on how to do this on a line chart ?

Re: Line Graph Accumulation

MatheusC — Mon, 27 Oct 2025 19:58:39 GMT

@johnnyjohn

Try using aggr() with your field ordering

aggr(
RangeSum(
above(
Sum(n5_value_EUR)
/
sum( total <n0_marketcap_group> n5_value_EUR),0,RowNo())),
(n0_marketcap_group,(=Sum(n5_value_EUR),Desc)),Clock)

Re: Line Graph Accumulation

johnnyjohn — Tue, 28 Oct 2025 07:11:13 GMT

Hello, thanks for the suggestion, no luck with the expression unfortunately. Below is a simple sample dataset, just in case it helps you create the expression for the line graph.

On a line chart, Group=Clock (continuous axis), Line=n0_marketcap_group, Height Of Line= the expression that makes this relative cumulative sum per market cap.

Many thanks

+-------------+------------------+----------------+ |n5_value_EUR |n0_marketcap_group| Clock | +-------------+------------------+----------------+ | 5082 | Mid | 0.00 | | 1436 | Mid | 0.03 | | 1286 | Mid | 0.23 | | 2275 | Mid | 0.23 | | 1483 | Mid | 0.54 | | 1755 | Mid | 0.54 | | 1628 | Mid | 1.00 | | 39759 | Small | 0.00 | | 1904 | Small | 0.50 | | 364 | Small | 0.50 | | 3683 | Small | 0.50 | | 1281 | Small | 0.53 | | 618 | Small | 1.00 | +-------------+------------------+----------------+

Re: Line Graph Accumulation

MatheusC — Tue, 28 Oct 2025 17:51:19 GMT

I ran some tests here and adjusted how it sorts and assigns the correct formatting to the fields.

Aggr(Rangesum(Above(Sum(n5_value_EUR)/Sum(TOTAL <n0_marketcap_group> n5_value_EUR),0,RowNo())),(n0_marketcap_group, (TEXT)),(Clock, (NUMERIC)))

To follow this continuous line, adjust Appearance > Presentation > Missing values (Show as connections).