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

How do I filter a computed field in a report

Received Response
22
Views
9
Comments
edited Mar 28, 2018 12:57PM in Reporting & Analytics for B2C Service 9 comments

Content

I have created a variable called $IncidentTypeLength and used it to create a field called "Length".

The calculation is working properly, however, I cannot figure out how to filter out values of "Length" that are < 1.  I've tried creating a filter using the same formula as was used for the variable, which is:

to_number(instr(to_char(threads.note), 'the incident occurred')-to_number('3'))-to_number(instr(to_char(threads.note), 'incident type:')+to_number('15'))

But the Filter doesn't like that the threads.note is included in the formula.

I've tried using the variable itself, but the filter doesn't like that either.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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