How to filter a field in an insight's narrative and get a count for one value in that field

[Max]

I would look to maybe make ifelse calculated fields that only display data that you are looking for.

ifelse({field}='blue',{value},0)

Then run calculations on this field ^ and the other fields you have created.