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
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
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
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
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
Could you show us how you want the final table to look like?
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