Adjusting confidence score on SQL report

Question

Asana: https://app.asana.com/0/1203395976933379/1203777745149446/f

This report for Southwest is set to filter everyone under 50%. It needs to be 50-99%

Not sure how to adjust this line where I think it's set-

cast(max(d.ConfidenceScore) as decimal(5,2)) as confidence,

This is the report page: https://admin.southwestchurch.com/page/922

Answer 1

There's nothing in that SQL statement that is filtering by confidence score. It sorts the results by score, but doesn't do any filtering. Are you sure they actually have duplicates with score higher than 50?

Comments

In looking at the duplicate finder, I'm not seeing any duplicates in the higher percentage that are for anyone younger than 18.

---

They seem to think so. But maybe not. I'll close this and see what they say. Thanks!

---

@TinaStephens We could add a filter to only show matches with confidence score higher than 50. If we did though, it'd currently show no results. You'd add this above the last ORDER BY clause:WHERE d.ConfidenceScore > 50.0