I have a fairly simple working query where it is picking up review dates by open claims, there is a field called DONE. I need to have a count of the "DONE" check box (results are Y or N) and I can't figure out the expression builder for this
Basically, need to count per claim # how many Y and how many N so I can focus on those without any N
I don't want to know how many Review Done is completely blank/null because this data is from a sql database that the field is part of a 3 field task and sometimes the record keeping is not consistent.
Sample of how I would like to see the output:
Claim 123 Review Done Y is 5 and Review Done N is 2
Claim 456 Review Done Y is 2 and Review Done N is 0
Claim 789 Review Done Y is 0 and Review Done N is 1
Is there a simple way to complete this? TIA. I'm really rusty !!
Basically, need to count per claim # how many Y and how many N so I can focus on those without any N
I don't want to know how many Review Done is completely blank/null because this data is from a sql database that the field is part of a 3 field task and sometimes the record keeping is not consistent.
Sample of how I would like to see the output:
Claim 123 Review Done Y is 5 and Review Done N is 2
Claim 456 Review Done Y is 2 and Review Done N is 0
Claim 789 Review Done Y is 0 and Review Done N is 1
Is there a simple way to complete this? TIA. I'm really rusty !!