Missing week end dates

[smilingjohn]

Hi All ,

I amusnig the below expression to get the running total please let me know if this iscorrect . 

=if(IsNull(Category),
RangeSum(Above(TOTAL Count(RaisedDate),0,RowNo(TOTAL))),
RangeSum(Above(TOTAL Count({<Dept=P(Category)>}RaisedDate),0,RowNo(TOTAL))))

After this i see that some of the dates of the line chart missing with data , how can i achive this . 

as shown in the screenshot below From 2/29/2020ks  it is directly showing 3/21/2020 Can you please guide me on do  I make this correct 

[smilingjohn]

Hi Community any help on this 

[Kushal_Chawda]

would you be able to share sample with expected output?

[smilingjohn]

Thanks @Kushal_Chawda 

I want to have the runing total  for line chart and i see that thrre are nissing weekends . it should not be missing if there is no records it should carry on previous week data .  this should be cummulative 

and i am using the above mentioned expression 

Thanks in Advance.

[Kushal_Chawda]

do you want running total on Count(RaisedDate)? What is the dimension? Sorry I can't check qvw file

[smilingjohn]

Sorry I forgot to attach.
Now i have attached , I am trying to get the running total , but there are some weekend missing it.
Please do suggest me how to bring up the missing weekends.

[Kushal_Chawda]

do you want running total on Count(RaisedDate)? What is the dimension? Sorry I can't check qvw file

[smilingjohn]

Hi @Kushal_Chawda  

I want to show running total on 3 dates "RaisedDate", "DeliveredDate" and "ClosedDate"  and the dimension is Weekend(RaisedDate).

Thanks