Cummultive trics

[smilingjohn]

Hi All,

I have a very complicated requirement . which I am not able to do it from so many days , 

I hope this i will get some from this formum 

Basically i have to show a table with the dimension 'Start Date'

 and expression a Sum( JIraTIcket). 

Below are some sample  data and my outout 

Input Dta			Desired Ouput		Cummulative
WeekStart	JIrTickes		WeekStart	JIrTickes		WeekStart	JIrTickes
1-Mar-20	1		1-Mar-20	1		1-Mar-20	1
8-Mar-20	1		8-Mar-20	1		8-Mar-20	2
15-Mar-20			15-Mar-20	1		15-Mar-20	3
22-Mar-20	2		22-Mar-20	2		22-Mar-20	4

If you look into the first table which is the input , well in this the data on 15-mar is missing , therefore in my desired table it shoud keep the value of the prious date and contineu the same till it gets any new jira tickets, . 

I trid this using range sum finction but that doensot help me . 

Can someone please help me n this 

[Frank_Hartmann]

script:

LOAD * INLINE [
WeekStart, JIrTickes
1-Mar-20, 1
8-Mar-20, 1
15-Mar-20,
22-Mar-20, 2
];

straight table (uncheck "omit zero values" on presentation tab):

dim: WeekStart

exp1: if(sum(JIrTickes)=0, above(sum(JIrTickes)),sum(JIrTickes))

exp2: RangeSum(Above(if(sum(JIrTickes)=0, above(sum(JIrTickes)),sum(JIrTickes)),0,RowNo()))

[smilingjohn]

Hi Frank thanks for the reply

[smilingjohn]

Any Solution on this would be really helpfull

[Frank_Hartmann]

can u share the qvw?  maybe with reducing the datamodel to the essential data and then scrambling remaining sensitive fields (settings - docsettings - scrmbling).