Last weeks customer satisfaction report

Question

Hello,

I'm looking to create the following report:

- Customer Satisfaction from the previous week,

I already created a report and my JQL is the following:

project = CS AND Satisfaction IS NOT EMPTY AND created >= startOfWeek(-1w) AND created <= endOfWeek(-1w)

I'm using JQL filter in series: filter = "Previous Week's Satisfaction"

Previous Week's Satisfaction is the name of the filter.

Even after I save, it doesn't show the previous week, and it defaults to the default setting of "Show past 7 days, Custom range, etc."

Maybe this is overriding my JQL filter. Do I need to remove it and if so, how? If I need to do something else, please let me know!

Markus_mzzqki · Answer

Thank you Danut, I will look into it! :)

Markus_mzzqki · Answer

Thank you, Hannes, I will look into it! :)

Danut M _StonikByte_ · Answer

Hi @Markus,

Try also the gadgets offered by our Great Gadgets app. They work with a filter or JQL as data source.

By using the Issue Filter Formula gadget you can display the Average Customer Satisfaction Score for the issues in a filter - in your case the ones created last week. The result can be displays in various ways.

On a 5-star scale:

As gauge chart:

Also, with the Advanced Issue Filter Formula gadget offered by the same app you can display additional stats like in this example:

You could start with a 1-month free trial. If you have any questions, feel fee to contact us at support@stonikbyte.com.

See also this article: https://community.atlassian.com/t5/App-Central/An-effective-dashboard-for-Service-Desk-and-Customer-Support/ba-p/2360369

Hope this helps.

Danut.