We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
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!