Filter dependencies

[annie_bananie]

Hi,

I need to omit the following entries from my data set:

Findings that -
a) are in an “Approved” Resolution Status AND
b) Have the same First Found and Resolved Date

Essentially,
${fact_findings.found_date} != ${fact_findings.resolved_date} WHERE ${fact_findings.resolution_status}= “Approved” something to that effect

How would I set this up?

[Cyril_MTL_Analy]

You’re probably looking for the sql_always_where parameter.

You would be using it like so

explore: foo {
   sql_always_where: ${fact_findings.found_date} != ${fact_findings.resolved_date} AND ${fact_findings.resolution_status}= “Approved” ;;

[...]
}