You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Filter by year

edited Apr 25, 2018 4:12PM in Reporting & Analytics for B2C Service 2 comments

Content

Hello,

I'd like to offer my users the ability to filter incidents by the year the incident was created.  I've figured out how to create a calculated field that shows just the year of that date, and how to use that field to create a relative filter by year.  But this filter is not intuitive to my users and they have to do math to get it to work - for example, want to see incidents from 1996? um... 2018-1996 = 22, type in 22, oh yeah, gotta remember the "-" sign.

I'd rather let them simply type in the year they are interested in either as a  single year or a between, or give them a pick list with check boxes for each year that exists in the incidents table.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!