Logical line chart

[smilingjohn]

Hi All,
I need to show a cummulative line chart but with some logic .

Normally cummulative will kepp on adding its previous values to the current one .

I want to show a cummulative line chart of tickets by Week Start.
and my out put should be like shwon below .
Here on 2-Feb-2020 I had a ticket opened therefore the cummulative of 2 is showing on 9th and 16-Feb-2020
(As there are no records on these weeks) but on 23-Feb-2020 there is a ticket therefore the line chart should
show me 1 ticket on 23-Feb-2020 and for nex week thtere are no tickets then it should continue showing 1 only
that is on 1-Mar-2020 it show one .

How do I achiev this ? as of now my cummulative is adding everything and shwoing up .

My formula is like this :

rangeSum(above(TOTAL count(Tickets),0,RowNo(TOTAL)))  

My Line chart should like the below one 

output:

Week Start        Tickets
2-Feb-2020          2
9-Feb-2020           2
16-Feb-2020       2
23-Feb-2020       1
1-Mar-2020         1
8-Mar-2020         4
15-Mar-2020       1

Thanks in Advance

[smilingjohn]

Hi All,

Any Solution on this would be really helpfull . 

Thanks 

[smilingjohn]

Hi Expertise any help

[anushree1]

Hi

The requirement is not very clear , could you provide a sample input and also the desired output for a better understanding?

[smilingjohn]

Hi Anushree

I have to show ticets by every weekstart.

I dimensions I use weekstart and expression have count (ticket).

My weekstart are like , 9-feb2020,15-feb-2010 23-feb-2020

Now if my ticket is opene on 9th-feb-202 then the trend line should show 2 tickets on 15 and 23 -feb as well . And say for example on 1 mar-2020 another tickets tickets opens then the 1 ticket shoulg be shown till all the weekstart unless there is any open ticket to any weekstart.

Thanks