I am comparing some field which are coming from different tables
Expression is like
Count( Distinct If(createdDate <= CalendarWeekEnd AND
Report_type = ‘Error’ AND
Priority_id = 1 AND
My data contains report_id and every report_id is reported on one or more product_ids and every has different priority. So I wanted to calculate those report_ids irrespective of product id based on priority id.
As my existing expression is written in If so it would be very difficult for me to convert it into set analysis (8-9 comparisons related to dates in If that would be time consuming from development point of view)