KPI object: filter with field null

[#1]

Hi guys,

i need to use a count (distinct *) in the KPI object when the field_date is null.

For example:

Count(distinct {$<[field_date]-={"NULL"}>} cliente)

Thanks,

[sunny_talwar]

When field_date is null? or is not null?

For null, may be this:

NullCount([field_date])

[sunny_talwar]

I guess I am not sure what you are trying to calculate here. What exactly are you trying to count? Would you be able to share a sample with expected output here?

[#4]

Example:

client	field_data
1	31/05/2016
1	01/06/2016
2
2	31/05/2016
4	31/05/2016
5	01/06/2016
5

Query:

select count(distinct client)

from table

where data_field is not null

Result count: 4

Thanks!

[sunny_talwar]

May be like this:

=Count(DISTINCT {<client = {"=Len(Trim(Concat(DISTINCT field_data))) > 0"}>} client)