How to create a second set of metrics, stats count by the field within the same table?

[IRHM73]

Hi, I wonder whether someone may be able to help me please:

I'm using the following query to record customer ratings and comments:

`frontend_wmf(ExitSurvey)`
| fields detail.whatDoYouThink detail.comments
| table detail.whatDoYouThink detail.comments

This produces, as I would expect a table of ratings and customer comments on the same row for the given number of events for the day:

Which looks like:

What I'd like to do, almost as a second set of metrics, is to produce a stats count by the field detail.whatDoYouThink but within the same table.

Could someone tell me please is this possible?

Many thanks and kind regards

Chris

[IRHM73 · Accepted solution]

Hi, although a little different in design, I've come up with the following which captures all the results:

`frontend_wmf(ExitSurvey)`
| fields detail.whatDoYouThink detail.comments
| stats list(detail.comments) as Comments sum(detail.whatDoYouThink) as "Rating_Total" by detail.whatDoYouThink
| rename detail.whatDoYouThink as Rating
| table Rating "Rating_Total" Comments

Many thanks to all for your help.

Kindest Regards

Chris

[IRHM73]

Hi, thank you for taking the time to reply with a solution.

I've made an amendment to my original post to show what I'd like the table to look like if possible.

Many thanks and kind regards

Chris

[somesoni2]

You can use eventstats command to add the count field without reducing the number of rows.

`frontend_wmf(ExitSurvey)`
 | table detail.whatDoYouThink detail.comments
 | eventstats count by  detail.whatDoYouThink

[damien_chillet]

Could you show us how you want the final table to look like?

[IRHM73]

Hi, thank you for taking the time to reply.

I've amended my original post to show the table I'd like to try and get please.

Many thanks and kind regards

Chris