Last weeks customer satisfaction report

[Markus]

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!

[Rilwan Ahmed]

Hi @Markus ,

Welcome to the community !! Please user this JQL. 

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

[Danut M [StonikByte]]

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.

[Markus]

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

[Hannes Obweger - JXL for Jira]

Hi @Markus

I'm not quite sure why your JQL statement wouldn't work in the report - but just in case you want this resolved quickly, you may want to have a look at the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields - including the satisfaction rating, satisfaction rating date, and satisfaction comment - much like you’d do in e.g. Excel or Google Sheets. You can 

This is how it looks in action:

As you can see above, you can easily sort and filter by your satisfaction fields, and also use them across JXL's advanced features, such as support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

As every JXL sheet is powered by a JQL statement or saved filter, it should be easy to pull in last week's issues with the JQL query you posted above. If it's easier, you can also use JXL's column filtering to filter for absolute or relative date ranges.

Any questions just let me know,

Best,

Hannes

[Markus]

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

[Markus]

Hi Rilwan,

Thanks for the help, unfortunately, this also seems to work in the "Filter" view, but it didn't work in the "Report" view for me even after updating the filter with your suggestion.

I'm trying to get a "Report" from last week's satisfaction results, but for now, it still shows a week from this date. Something seems to override the filter that I set.