Earn badges and make progress
You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
Next: Root
1 badge earned
Participate in fun challenges
Challenges come and go, but your rewards stay with you. Do more to earn more!
Gift kudos to your peers
What goes around comes around! Share the love by gifting kudos to your peers.
Rise up in the ranks
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Come for the products,
stay for the community
The Atlassian Community can help you and your team get more value out of Atlassian products and practices.
can I create a pie graph that sums up all the categories into fewer categories?
I'm including a visual to help explain this.
I needed a way to see how many tickets were "Historically" Past Due in Confluence(meaning the ticket didn't make the due date, but is now resolved), so I created a "Duration of Days to Complete" Field with an automation set that compares the "Resolved" date to the "Due Date" within each ticket, and then spits out the day difference between the two.
>Positive days means the task missed the deadline by that many days
>Negative days means it was done early
>"0" means it was done ON the due date.
Now here's the question --> How can I add up the total of all tickets done early to present a Percentage? So we can look at a pie graph and say "We made 85% of our due dates" (or whatever percentage). Ideally, I'm looking to see Made It, Missed It, and None (for those that don't meet the calculation criteria thus have no info in the custom field).
1 answer
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.