rel_date_diff as a report filter
SummaryI have a report that requires rel_date_diff as a filter
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:
- $rel_time_open (type = replacement value) : rel_date_diff(sysdate(), incidents.created, 1)
- $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"