How many instances of "r" are there in:
Basically I want to show how many tickers per user was created in amount of time.
Example: we have 100 tickers a month and total 10 users. The output will be 10 tickers/user a month.
Dave's advice is on point here, but I also understand the need for proper tracking. If you are out of scope for Jira's built-in reporting features, there is a variety of tools on the Atlassian Marketplace.
As a Marketplace Vendor, I can't escape recommending our app Custom Charts for Jira. By simply adding the Custom Charts Gadget to your Jira Dashboard, you can quickly pull any Jira & JSM data and share it with your team.
Should you have the information, what are you going to do with it? What purpose does it serve?
This is for business requirements. Better IT training for non-IT users in our environments. Some user just raise the ticket to request for the things they does not really needs. Just want to make sure user only create the ticket when they're actually understand what they need.
There are may other ways to accomplish this. Rather than analysing invaluable numbers like 'x issues/user creating during the last period', try interviewing your non-IT users by asking what they need in order NOT to create an issue for their request or problem.
Some issues simply cannot be avoided because people need 'things' and creating an issue is the formal process, either for tracking or approving.
On the other hand, providing a knowledge base with how-to articles, troubleshooting articles and easy-to-find procedures, guidelines, etc. help non-IT users in "self-serving".
Hi @Dave Mathijs thanks for your valuable advise. I can totally understand that but let call it phase number 2. And for now, is anyway I can create the dashboard like that or this is the limitation ?
As an alternative, you can try Time in Status for Jira Cloud with its Pivot table function.
You just need to set up Pivots according to your needs and get the total number of tickets created per user.
This add-on is developed by my team and is free for using up to 10 users. Let me know if you have any questions.
Here is a sample report that shows number of tickets per reporter on each month.

user
The text includes 128 "r"s in total.
assistant