Edit expession- agg part of the pop with conditions

[Yam1]

Hi. I want the table in dashbord to show only those whose field 'Error_ind'  is equal to 1 and in these cases , if the field 'query_number' includes the values ('bcif_010','bcif_011') ​​then sum of the field 'error_ind' else maximum for the field 'failedkey'

Thanks

 

[stevejoyce]

If I understand correctly, this calculation?

If(match(upper(Query_Number), 'BCIF_010', 'BCIF_011'),
sum(Error_Ind),
max(failedkeys)
)