Filter for Number Greater Than

Hello,

I am new to Alteryx and trying to learn as I go.

I am trying to use the filter to split between true/false for data in a column greater than 90 but I end up getting the output to be incorrect. In a previous formula I set it up to take the last log in date and give me a number which looks like this: DateTimeDiff(DateTimeToday(),[Last Login Date],"days")

I then want to filter for any number greater than 90 and created a test document with a couple of different ranges of dates. What I am expecting is true to be everything over 90 and false to be under but what I get under false is 4, 366 and 247.

I cant figure out why my three digit numbers come under false. This is the filter I am using [Days last login] > "90"

filter more than 90.JPG

Thanks

Date Time

Accepted answers

binu_acs

@fmontante One way of doing this

All comments

gautiergodard

Hey @fmontante

Is this what you are looking for?

Perhaps just ensure that the field you are filtering on its a numerical data type... double, Int ...etc.

filter1.yxmd

fmontante

Hello,

Thanks for the reply. That did not work unfortunately.

Is there a way to make sure the field is numerical data type?

binu_acs

@fmontante One way of doing this

fmontante

That worked! Thank you!

DataNath

@fmontante in the formula tool where you set up the expression to perform the datediff calculation, make sure the data type is set to something numeric (double, integer etc) - by default new fields being created in the formula tool are set to a string so I’d imagine that’s the issue in your initial approach.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703