Cummulative logic in a chat

[Anonymous]

Hi  Team

I have two requirement  as per below scenario .

1. I want to find whether the CR field is Null or Not

2.  I want to count the CR filed  counts  as per  below logic

        Logic

            If CRs  field NOT NULL, then increment count by 1
Note :Users expect this cumulative count as the count of total  CRs

I am   Sharing the sample data and  sample QV report .

Please help me on this   

Thanks in advance !

Regards

Mahesh.

[sunny_talwar]

What is the expected output (in numeric terms)?

[Anonymous]

Hi Sunny

Yes the expected output will be in numeric .

for example if we CR  like  34;56;78;92 we coinsder it as single value

[sunny_talwar]

Right so what is the values you are expecting to see then?

[Anonymous]

Sunny

  if  i  use count(CR) in the expression  i was able to see the count of  CR  for that particular Month.

But the problem occurs   when i what to see in cumulative  form  .

If I select the multiple CRS  here i want to display the  1 record+2 +3 like this

please find the attached screen shot  if i am not clear

[sunny_talwar]

Mahesh -

I am still not sure what you want buddy. I really want to help but don't know what are the numbers you are looking to get here?

For Dec, we have 1, Jan we have 2.... is this not right? what is that you want instead?

[sunny_talwar]

The screenshot clarifies what you want, thanks for that

[sunny_talwar]

This?

[Anonymous]

Thanks Sunny  For the Clarifying  my Question  it help me a lot .

For the sample  data  which i had currently  it is getting the exact output as per my requirement . Tomorrow  i will check the  original  data  which i had i will update you if i required anything .

One more thing   in the above requirement. I want to handle the null also  where the data blank in CRS  is i want to display it as NULL or 0 .

Please advice me on this also

[sunny_talwar]

Isn't it already doing that? CRS is null for oct and we don't see oct in the bar chart, right?