Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Filtered Report by Month

Preston Warden
Contributor
July 23, 2021

Here is a fun request:

 

I am trying to create an alert that allows for me to send an email of all users we have in the system and what tickets they created and quantity by month and project.

 

The design would be such as the screenshot but:

 

Employee Name Down Left

Month and year across the top (I would want two graphs, one of the entire year and one of the quarter)

How many tickets per month of project (IDEA) submitted

How many total to the far right per employee

How many total to the bottom per monthPicture1.png

 

Programs I have: Powerscripts, Project Automation

1 answer

0 votes
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 23, 2021

Hi @Preston Warden 

What problem are you trying to solve by creating this report?  Knowing that may help members of the community to offer you suggestions.  Thanks!

Best regards,
Bill

Preston Warden
Contributor
July 26, 2021

Hi Bill,

 

Our team uses the above metrics to determine participation. Currently, they are doing this manually, but by doing this we are able to see all results as we need them and quickly.

Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 26, 2021

Thanks for that clarification, Preston.

First thing, I do not believe there are any out-of-the-box reports to do this.

Is "determine participation" a short-term or a long-term need to help address this situation?  Or put another way, is this something which recently was noticed as a problem?

If this is a short-term situation, I suggest using data exports and create reporting in a spreadsheet tool, or use the REST API or webhooks to get the data into another reporting tool.  Then once the problem is addressed, focus on the next challenge/opportunity to improve upon and perhaps stop measuring this item.

If participation measurement is a long-term need, you may want to investigate reporting addon products from the marketplace.  However, I respectfully suggest discussing such long-term measures with the teams, their leaders, and coaches.  Helping people understand the goals and desired behaviors using such measures may provide more sustainable benefits.

Thanks!

Preston Warden
Contributor
July 26, 2021

Hi Bill,

 

This is a long term need. We have processes that this feeds into which work towards bonuses. Essentially determining if the team members are participating each month per the incentive program. 

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
TAGS
AUG Leaders

Atlassian Community Events