count of blank records

[bhavvibudagam]

Hi Everyone,

I have one field called country. In country I have some blank records. Please help me on how to calculate the Blank records in that field.

I have attached the sample data excel file here.

In the excel out of 16 rows I have 7 blank records. How to get the count of blank records.

[sergio0592]

Try with :

=count({ $<Country={''} > }  Country)

[pradosh_thakur]

try this

sum(isnull(Country)=-1,1,0)

else

sum(if(len(Country)=0,1,0)

regards

Pradosh

[Chanty4u · Accepted solution]

try this

=NullCount(Field)

[its_anandrjs]

Can you check this script as well as in the load script.

In script load do this way

LOAD *,if(IsNull(Country)=-1 or len(Country)=0,'Null',Country) as CountryChk;

LOAD * Inline[

Country,Id

a,10

b,20

c,30

,40

d,50

e,60

,50

f,80  ];

And on UI count it in any text or chart

=Count( {<CountryChk={'Null'}>} Country)

[vishsaggi]

Try this?

LOAD RowNo() AS Rows, IF(Len(Trim(Country)) = 0, Null(), Country) AS Country

FROM

[..\Desktop\Sample data - Country.xlsx]

(ooxml, embedded labels, table is Sheet1);

Use like

= Sum(IF(ISNULL(Country) = -1, 1, 0))

[its_anandrjs]

On the result to you have any confusion or you looking something else on this let me know.

With Flag field

=Count( {<CountryChk={'Null'}>} Country)

With SET Analysis

=count({ $<Country={"=Len(Country)=0"} > }  Country)