Expressions

[Anonymous]

**Update**

I have this straight table expression ==count({<Date = {[<>NULL]}>}distinct ID)

I really need to understand what is being counted and how would I write the above expression in the script editor, something like this, IF(date <> 'NULL', 1,0) as DateCount? (Where would I add the distinct ID)

[#2]

[Colin-Albert]

The expression is showing a distinct count of ID, for rows in the current dataset where the Date is not null

[Anonymous]

Thanks, I've updated my question to be more clear. Would you mind taking a look?

[Anonymous]

How would that look in the script editor?

[NareshGuntur]

Hi John,

I think there is an issue with the expression.

<>NULL will not be treated as "not equals to". It should be written as Date =- {[NULL]}.

Here, it will consider only the greater than symbol.

Cheers,

Naresh

[Colin-Albert]

It depends on your data model.

Are the Date fields and ID fields in the same table?

If yes, then you could add this to your load script      if(Date, 1) as DateCount

then use sum(DateCount) in your charts

[settu_periasamy]

Hi,

Do you have Null Value in your Date Field? Then, you can try this in the script, Like

if(isNull(Date) or Len(Trim(Date))>0,1,0) as DateCount

in Expression something like..

=count(Distinct {<DateCount={1}>} ID)

or

=Sum(Distinct DateCount)

[Anonymous]

Null is the acutal value in the field.

My straight table Expression is ==count({<Date = {[<>NULL]}>}distinct ID)

Really wanting to write this out in the scrip editor and just sum in the charts.

Something list this...IF(date <> 'NULL', 1,0) as DateCount? Will this work and does it take into account the "distinct ID" piece of the first expression?

[Anonymous]

Okay on the right track! There are not null values but there is a value called "NULL"