Use Custom Expression on Level Filter
I need to use the following custom expression on level filter, both top level and drill-down level.
- $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.