Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try with :
=count({ $<Country={''} > } Country)
try this
sum(isnull(Country)=-1,1,0)
else
sum(if(len(Country)=0,1,0)
regards
Pradosh
try this
=NullCount(Field)
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)
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))
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)