Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, last time I asked the question : how to select data when for example I want only the YES data.
ex :
count({<[REACH Rem]={'Y'}>}[REACH Rem])
How do I do the same request but with blank data (= nothing in the cell?) I tried {' '} but it does not work.
Thanks in advance
Hi Aurelie,
You could start with
count({<[REACH Rem]={''}>}[REACH Rem])
Thats '' instead of ' ' (no space).
Otherwise it's gonna be counting and selecting so called null() values and to be honest, I have to check how (and if) it works.
Grtz. Fred
Hi Aurélie,
That "blank data" is actual data or null values as a result of an aggregation where no values were provided?
In the first case, I'd better use any other character to replace blanks or spaces and avoid confusion, in the second, you should need how null those null values are to be able to select them (basically, following the whitepaper and explanation here: Finding NULL)
Miguel
Hi,
Try this type of expression.
=if([REACH Rem]<0,[REACH Rem])
Hi,
Try like
count({<[REACH Rem]={"=isnull([REACH REM])"}>}[REACH Rem])
Regards,
Hi,
You may try
if( isnull( [REACH Rem])=-1,'BLANK',[REACH Rem])) as Dimension.
most probably blank data is not selected in dimension of any chart.
Regards
Vimlesh
Dependant upon whether the value is actually NULL OR MISSING, you could use
NullCount([REACH Rem]) OR MissingCount([REACH Rem])
OR try
=Count({$-<[REACH Rem]={'?*'}>}REACH Rem)
Andy
Hello Aurelie,
The expression to select the blank data is
=count({<[REACH Rem]={''}>}[REACH Rem])
That's '' instead of ' '.
' ' has one space and '' is actually a blank value.
count of ' ' is trying to find values consisting of 1 space which is not present in your data.
count of '' will give you the correct result.
Thanks and Regards,
Ankita