topic Re: Excluding NULL & -ve Values in Visualization and Usability

Excluding NULL & -ve Values

DipeshVadgama — Mon, 14 Aug 2017 15:14:35 GMT

Hi,

I am trying to do set analysis in Strange table to exclude date which are blank & Day Rem which are in negative.

=Count({<[User ID]={'=Len(Trim([Complete Date]))=0'},[Days Rem]={"<=0"}>}[User ID])

But in not get required result.

aarkay29 — Mon, 14 Aug 2017 15:17:46 GMT

May be this

Count({<[User ID]-={'=Len(Trim([Complete Date]))=0'},[Days Rem]-={"<=0"}>}[User ID])

sunny_talwar — Mon, 14 Aug 2017 15:17:55 GMT

May be this

=Count({<[User ID] = {"=Len(Trim([Complete Date]))>0"}, [Days Rem]={">0"}>} [User ID])

DipeshVadgama — Mon, 14 Aug 2017 15:24:29 GMT

No Result

Example Data

I Need count as 4

Anonymous — Mon, 14 Aug 2017 15:27:42 GMT

is your [Days Rem] field really numerical?

you could try

LOAD

...

num(num#([Days Rem])) as [Days Rem],

...

DipeshVadgama — Mon, 14 Aug 2017 15:32:18 GMT

Yes I did converted dates to dated format and number to number format.

sunny_talwar — Mon, 14 Aug 2017 15:34:06 GMT

Would you be able to share your app?

Anonymous — Mon, 14 Aug 2017 15:34:27 GMT

does every "User ID" have exactly 1 "completed Date"?

DipeshVadgama — Mon, 14 Aug 2017 15:40:14 GMT

Please find App And Excel File.

sunny_talwar — Mon, 14 Aug 2017 15:42:58 GMT

Your field name is Completed Date and not complete date

=Count({<[User ID]={"=Len(Trim([Completed Date]))=0"},[Day Rem]={"<=0"}>}[User ID])

DipeshVadgama — Mon, 14 Aug 2017 15:45:06 GMT

Oh my god, Thanks you. I did not realized that. Its works not.