Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Use Custom Expression on Level 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

Use Custom Expression on Level Filter

Accepted answer
11
Views
2
Comments
edited Jun 15, 2022 9:55PM in Reporting & Analytics for B2C Service 2 comments

Hi,

I need to use the following custom expression on level filter, both top level and drill-down level.

If(date_diff(sysdate(),$max_date_created)<>0,date_diff(sysdate(),$max_date_created),$date_creation)

Variables:

  • $max_date_created = max(threads.entered)
  • $date_creation = date_diff(sysdate(),max(incidents.created))

The above script works when used to filter the drill-down level as Group filter, but not for the entire report filter nor top level that only have 'prod_hierarchy' and 'count(distinct incidents.ref_no)' columns (see error message attached). When used as a Group filter on top-level it is pulling incorrect case count. Thus, I'm trying to apply it throughout all levels.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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