Forums

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

Project "Credit" Balance (Monthly)

Alan Shurack
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
April 4, 2019

We have a Jira Cloud Support Desk instance, and have a requirement to track customer credits used. Cloud limits a lot of what we can do, so I hope someone has a way to do this, whether through extreme-Ninja JQL, plugins, or some combination of the two. Here's the use case;

Each support desk customer has a monthly allotment of credits; to make this easy, we'll say the monthly allotment is 10, but in our use case we need to be able to assign different monthly credits per customer/project, eg Customer A has 10; Customer B has 25. I'm assuming for the moment this would be set as a project-level custom numeric field, Monthly Credits. As issues are created, they have a Credits Used value per issue, based on issue type, eg Support Request is worth 1 credit, Enhancement Request is worth 2. We sum those per calendar month, then have a calculated field Credit Balance that is (Monthly Credits-(sum of Credits Used in <current calendar month>)+(Monthly Credits-(sum of Credits Used in <previous calendar month>)

1 answer

0 votes
Nic Brough -Adaptavist-
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.
May 14, 2019

I have seen this done before, but it was not the most neat solution, it was on Server and may rely on functions you can't quite get on Cloud.

The short version is that we used ScriptRunner to calculate some simple scripted fields on every issue, working out the points they each consumed, then used Profields to display these on a project level.  Both of these apps exist for Cloud, but I know SR is limited by Cloud architecture and hence may not quite do what you need.

In the interests of openness - I work for Adaptavist - this means we do most automations with that instinctively, so it's the main one I have worked with.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events