Count how many time NAME have Null on Flag field ?

[#1]

Hi All

I try to count how many time user have null on Flag, i use

My chart expression = count(distinct(Flag=Null))

it does not able to work.

Any advise ?

Paul

[sivarajs · Accepted solution]

count((if(Flag='Null',Name)))

[jonathandienst]

Hi

To count nulls in the Name field:

=NullCount(Name)

HTH

Jonathan

[salto]

Hello,

try with this expression in the chart:

  = count((Flag='Null'))

Hope this helps.

[CELAMBARASAN]

You could use something like this

=Count({<Flag={'Null'}>} Name)

[#6]

Hi All

Thank you very much for all the help . I notice that only Siva script working , may be because he Add NAME in the script.

I have next follow up question , may i know how to make the Top of bar display the number of count , now it display 00:00

How to make it display 1 or 3

Paul

[sivarajs]

Change the number format to integer. You get number option under chart properties

[CELAMBARASAN]

Hi,

Change the number format in the Number tab, you specified it as Time.

I prefer to use set analysis which is cost effective, Count({<Flag={'Null'}>} Name).

[#9]

Hi Cela

Yes now it work fine on display count number on top of the bar.

Can you tell me why SET analysis is better ?

Paul

[CELAMBARASAN]

Set analysis filters the data from the datamodel before it applies dimension based evaluation. But using if condition, filter applied on the dimension evaluation.

To say simply, Set analysis filters the data based on the condition in whole data set and applies the filtered data to the dimension values. But the if condition apply filters for each and every dimension values.