Overlapping Line Graph For Bad CSATs By Month | Community
Skip to main content

Overlapping Line Graph For Bad CSATs By Month

  • July 13, 2021
  • 1 reply
  • 0 views

Hello,

I'm looking to make a query to show the number of Bad CSATs for each day in a given month, showing how many Bad CSATs were reported by Ticket Topic (Late Orders), and have the graph also show the line for the CSAT%. Basically, this would help reflect how the number of the tickets with a specific Topic affected the overall % of our CSAT.

Is there a recipe for this, or is this even possible? Thank you!

This topic has been closed for replies.

1 reply

Andrei12
  • July 18, 2021

You should build a combo chart with 2 metrics - (1) Bad ratings and (2) CSAT Score (make it Dual type). Then apply a filter using field value or tag - depending on now your Ticket topic is organized. The attribute should have "Date Solved" accordingly.