How can I get stats based on unique Id?

[batham]

Hi folks,
below are the log snippet that I am working on to generate a report

dare=10-05-2023,uniquieId=123 ,Request body: {"name":"test123","id": "Id123"}
dare=10-05-2023,uniquieId=234 ,Request body: {"name":"test234","id": "Id234"}
dare=10-05-2023,uniquieId=345 ,Request body: {"name":"test123","id": "Id345"}
dare=10-05-2023,uniquieId=123 ,Response body: {"role":"1"}
dare=10-05-2023,uniquieId=234 ,Response body: {"role":"2"}
dare=10-05-2023,uniquieId=345 ,Response body: {"role":"1"}
....
....
....
.....

I want daily stats on name and role, how do I combine the result based on uniquieId .
as below

date                    test123         test234
10-05-2023           2                     1

[ITWhisperer]

Assuming you have already extracted the fields, try this

| chart count by dare name