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.

[Anonymous]

Not in chart  sunny , i want it to display in list box

in the List i was able to see Blank spaces in the original data  i had, i cant share you that .

please advice me how to handle NULL in such cases and Display it as ZERO or NULL

[sunny_talwar]

May be handle it in the script:

LOAD Year,

    Month,

    Num,

   If(Len(Trim(CRS)) = 0, 'NULL', CRS) as CRS

FROM

(ooxml, embedded labels, table is Sheet1);

[Anonymous]

Thank you Sunny for spending your time on my issue .

[sunny_talwar]

No problem at all

I am glad I was able to help

[Anonymous]

Hi Sunny

when I am calculating the% in line.  and  I am using  Full Accumulation  option

then it shows wrong  for example if  Dec2016 I am having 100 % and  Jan 2017 is having 100 %  it shows as 200% in the output

My expected output was  I am having IR count as 2  for JAN and when I use full accumulation pervious month will be added I.e 1  total IR count was 3 .

For CR also same  Logic  so count Should 3 .

Then CR/IR = 3/3 = 100%

Please help me on this

I am sharing the sample  QV and data

[sunny_talwar]

What is CR and is IR brother? I am not sure I understand what you are looking for. Can you make sure that your sample qvw is inline with what you are saying here

[Anonymous]

Hi Sunny

I am expecting 100 % , Here is sample Qvw I had load data in Inline

Please have a look

Thanks

[sunny_talwar]

Then don't accumulate your last expression?