Create expression for ACUMULATED values

[#1]

Hello

How can I create an expression to accumulate values like shown in the picture:

Thanks!!

[Gysbert_Wassenaar]

try:

load

day(Fecha_Creacion) as Day,

Empleados,

if(rowno()=1,Empleados,Empleados+peek([Empleados Accum])) as "Empleados Accum"

from .... etc

[#3]

Thanks Gys

I tried this but can´t seem to get desired result...

Empleados Accum does not exist in the source I am trying to create it as new in the Pivot Chart.

#Empleados is another calculated expression as: count(distinct employeeID) where employeeID is coming from source

[diegofcaivano]

Hi.

In that case, make a table object with DAY as dimension, EMPLEADOS as a first expression, and a second expression as follows:

EMPLEADOS + BELOW(EMPLEADOS, -1, 0)

Regards.

Edit: To consider the first row, here is the complete expression:

IF(ROWNO()=1, EMPLEADOS, EMPLEADOS + BELOW(EMPLEADOS, -1, 0))

El mensaje fue editado por: Diego Caivano

[swuehl · Accepted solution]

If you want to do this in the chart, there a two options:

a) use a second expression identical to your first

=count(distinct employeeID)

and activate 'full accumulation' in expression tab for that expression.

b) use as second expression

=rangesum(above(count( distinct employeeID),0, rowno() ))

Hope this helps,

Stefan