I need to create Easybi Reports for total number of tickets resolved and survey received.

Bhargav_5dlidg

Ilze Leite-Apine - eazyBI

Hi!

You may want to create the report with Time dimension Months in the report rows for a timeline. Use the same Time dimension in Pages to limit range of months in rows.

Then use measure "Issues resolved" in columns to get the count of resolved issues within each time period.

To count the issues with feedback, the approach depends on how do you store the information about the feedback.

• If you use Jira Service Management field "Satisfaction Rate" and "Satisfaction Date", then there is available measure "Issues with Satisfaction date" which counts issues having satisfaction date in this time period. Read: Satisfaction rating measures. Use this measure in columns.
• If you have a custom field in Jira, like "User Feedback Rating", then import it as a measure into eazyBI. Then a hidden measure "Issues with User Feedback Rating resolved" is imported based on this field: to unhide it, create a new custom measure (in Measures) with this measure as a calculation formula. Read: Totals of custom number fields.  Use the created measure in columns.

 

If you have a different use case (for instance, if you have this feedback informations in another data source) or have any questions, please, contact us at support@eazybi.com 

Ilze, eazyBI Customer Support