Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
rel_date_diff as a report filter — Cloud Customer Connect
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

rel_date_diff as a report filter

Accepted answer
27
Views
4
Comments
edited Jul 24, 2019 11:48PM in Reporting & Analytics for B2C Service 4 comments

Summary

I have a report that requires rel_date_diff as a filter

Content

HI,

I have designed an SLA report on Oracle Service Cloud, with the requirement to filter and show incidents or requests that have breached the defined SLAs only.

I have defined two variables as follows:

  1. $rel_time_open (type = replacement value) : rel_date_diff(sysdate(), incidents.created, 1)
  2. $sla : if(response_reqs.rslv_within > 0, response_reqs.rslv_within * 60, if(response_reqs.resp_within > 0, response_reqs.resp_within * 60))

Finally, I define a new filter which would compare $rel_time_open to $sla using the 'greater than' operator. However, this gives the following error: "- Usage of variable '$rel_time_open' does not include requested usage - filter"

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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