Returning true/false from a function field

[kim-lindgren]

I need to create a report that sorts incidents into groups: resolved < 1 day, resolved in 1-3 days, resolved > 3 days. 

We are not going to add new fields to the Incident table, so I think I have to use function fields. I believe I should create 3 function fields for the 3 different cases, but how do I get a function field to return a True/False value? I see that you can set Return type to True/False, but none of the Operations seem to make sense with a True/False evaluation. I would like to simply check (Resolve time < 86400) and return true or false for each incident, storing the final sum of true values (e.g. '500 incidents') in my function field.

The documentation is not making me much wiser.

Best regards,

Kim

[Uncle Rob · Accepted solution]

I'd investigate Report Ranges (link to docs) before I tried to tackle it with a Function field.

[kim-lindgren]

I didn't know that this feature existed. Thanks a lot!

[Uncle Rob]

You're welcome.  Gotta thank you for reminding me to move it up my video content list.