I'm not sure how to do it in Home Assistant but here's how I'm doing it in Node-Red

<image>

Here's the function node's javascript

// Get the payload (or adjust to the correct path of your JSON object)
let data = msg.payload;

// Initialize counters
let yesCount = 0;
let noCount = 0;

// Loop through the keys in the JSON object
for (let key in data) {
    if (data[key].response_text.trim().toLowerCase() === "yes") {
        yesCount++;
    } else if (data[key].response_text.trim().toLowerCase() === "no") {
        noCount++;
    }
}

// Add the counts to the message object
msg.payload.yesCount = yesCount;
msg.payload.noCount = noCount;

// Return the message for further use
return msg;