Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Aura divider
summaryIssues Past Due vs. On Time Issues
paramsJTdCJTIydHlwZSUyMiUzQSUyMnRleHQlMjIlMkMlMjJzdHlsZSUyMiUzQSU3QiUyMmFsaWdubWVudCUyMiUzQSU3QiUyMmhvcml6b250YWwlMjIlM0ElMjJjZW50ZXIlMjIlN0QlMkMlMjJpY29uJTIyJTNBJTdCJTIybmFtZSUyMiUzQSUyMmZhUGFwZXJQbGFuZSUyMiUyQyUyMmNvbG9yJTIyJTNBJTIyJTIzMzMzJTIyJTJDJTIyc2l6ZSUyMiUzQTI0JTdEJTJDJTIydGV4dCUyMiUzQSU3QiUyMmNvbG9yJTIyJTNBJTIyJTIzMzMzJTIyJTJDJTIyZm9udFNpemUlMjIlM0EzMiUyQyUyMnRleHRBbGlnbiUyMiUzQSUyMmxlZnQlMjIlMkMlMjJmb250V2VpZ2h0JTIyJTNBJTIybGlnaHRlciUyMiUyQyUyMnRleHQlMjIlM0ElMjJJc3N1ZXMlMjBQYXN0JTIwRHVlJTIwdnMuJTIwT24lMjBUaW1lJTIwSXNzdWVzJTIyJTdEJTJDJTIyYm9yZGVyJTIyJTNBJTdCJTIydG9wJTIyJTNBZmFsc2UlMkMlMjJyaWdodCUyMiUzQWZhbHNlJTJDJTIyYm90dG9tJTIyJTNBdHJ1ZSUyQyUyMmxlZnQlMjIlM0FmYWxzZSUyQyUyMmNvbG9yJTIyJTNBJTIyJTIzMzMzJTIyJTJDJTIyc3R5bGUlMjIlM0ElMjJzb2xpZCUyMiUyQyUyMndpZHRoJTIyJTNBMSU3RCUyQyUyMnNpemUlMjIlM0ElN0IlN0QlN0QlN0Q=

This chart shows issues that are past their due date vs. those that are not past their due date using a Scriptrunner Enhanced Search filter. Using this report, managers have insight into team workload and capacity. For example, if the team is constantly missing due dates, it could mean that team members don’t have bandwidth and we need to hire more people.

...

Aura divider
summaryRecreate This Chart In Your Own Instance!
paramsJTdCJTIydHlwZSUyMiUzQSUyMmljb24lMjIlMkMlMjJzdHlsZSUyMiUzQSU3QiUyMmFsaWdubWVudCUyMiUzQSU3QiUyMmhvcml6b250YWwlMjIlM0ElMjJjZW50ZXIlMjIlN0QlMkMlMjJpY29uJTIyJTNBJTdCJTIybmFtZSUyMiUzQSUyMmZhLWNoYXJ0LWNvbHVtbiUyMiUyQyUyMmNvbG9yJTIyJTNBJTIyJTIzMzMzJTIyJTJDJTIyc2l6ZSUyMiUzQTE4JTdEJTJDJTIydGV4dCUyMiUzQSU3QiUyMmNvbG9yJTIyJTNBJTIyJTIzMzMzJTIyJTJDJTIyZm9udFNpemUlMjIlM0EyNCUyQyUyMnRleHRBbGlnbiUyMiUzQSUyMmxlZnQlMjIlMkMlMjJmb250V2VpZ2h0JTIyJTNBJTIybGlnaHRlciUyMiUyQyUyMnRleHQlMjIlM0ElMjJSZWNyZWF0ZSUyMFRoaXMlMjBDaGFydCUyMEluJTIwWW91ciUyME93biUyMEluc3RhbmNlISUyMiU3RCUyQyUyMmJvcmRlciUyMiUzQSU3QiUyMnRvcCUyMiUzQWZhbHNlJTJDJTIycmlnaHQlMjIlM0FmYWxzZSUyQyUyMmJvdHRvbSUyMiUzQXRydWUlMkMlMjJsZWZ0JTIyJTNBZmFsc2UlMkMlMjJjb2xvciUyMiUzQSUyMiUyMzMzMyUyMiUyQyUyMnN0eWxlJTIyJTNBJTIyc29saWQlMjIlMkMlMjJ3aWR0aCUyMiUzQTElN0QlMkMlMjJzaXplJTIyJTNBJTdCJTdEJTdEJTdE

Recreate This Chart In Your Own Instance!

Part I: Create the 2 Enhanced Search filters, one for issues that have missed their due date, and one for issues that have not missed their due date. Use the functions below:

  • Past Due Date: issueFunction in dateCompare (“”, “resolutiondate <= duedate”)

  • Not Past Due Date: issueFunction in dateCompare (“”, “resolutiondate > duedate”)

Part II: Set up Custom Charts

  1. Set the Source to Projects and choose your desired project(s)

  2. Set the Chart type to 2D Stacked Bar Chart

  3. Set the Chart by dropdown to Due Date

  4. Set the Group by dropdown to Saved Filters

  5. In the Group by tab on the right, add in the 2 Enhanced Search filters you made

    Image Added

  6. Optional: Give your chart a title and and rename any segments

  7. Click Save or Insert

Aura divider
summaryAura Divider
paramsJTdCJTIydHlwZSUyMiUzQSUyMmljb24lMjIlMkMlMjJzdHlsZSUyMiUzQSU3QiUyMmFsaWdubWVudCUyMiUzQSU3QiUyMmhvcml6b250YWwlMjIlM0ElMjJjZW50ZXIlMjIlN0QlMkMlMjJpY29uJTIyJTNBJTdCJTIybmFtZSUyMiUzQSUyMmZhLWNoYXJ0LXBpZSUyMiUyQyUyMmNvbG9yJTIyJTNBJTIyJTIzMzMzJTIyJTJDJTIyc2l6ZSUyMiUzQTE4JTdEJTJDJTIydGV4dCUyMiUzQSU3QiUyMmNvbG9yJTIyJTNBJTIyJTIzMzMzJTIyJTJDJTIyZm9udFNpemUlMjIlM0ExNCUyQyUyMnRleHRBbGlnbiUyMiUzQSUyMmxlZnQlMjIlMkMlMjJmb250V2VpZ2h0JTIyJTNBJTIyYm9sZCUyMiUyQyUyMnRleHQlMjIlM0ElMjJBdXJhJTIwRGl2aWRlciUyMiU3RCUyQyUyMmJvcmRlciUyMiUzQSU3QiUyMnRvcCUyMiUzQWZhbHNlJTJDJTIycmlnaHQlMjIlM0FmYWxzZSUyQyUyMmJvdHRvbSUyMiUzQXRydWUlMkMlMjJsZWZ0JTIyJTNBZmFsc2UlMkMlMjJjb2xvciUyMiUzQSUyMiUyMzMzMyUyMiUyQyUyMnN0eWxlJTIyJTNBJTIyc29saWQlMjIlMkMlMjJ3aWR0aCUyMiUzQTElN0QlMkMlMjJzaXplJTIyJTNBJTdCJTdEJTdEJTdE

Aura inline button
summaryYouTube Tutorials
paramsJTdCJTIybGFiZWwlMjIlM0ElMjJZb3VUdWJlJTIwVHV0b3JpYWxzJTIyJTJDJTIyc2l6ZSUyMiUzQSUyMnNtYWxsJTIyJTJDJTIyc2hhcGUlMjIlM0ElMjJjaXJjdWxhciUyMiUyQyUyMnN0YXRlcyUyMiUzQSU3QiUyMmlkbGUlMjIlM0ElN0IlMjJjb2xvcnMlMjIlM0ElN0IlMjJiYWNrZ3JvdW5kJTIyJTNBJTIyJTIzZmYwMDAwJTIyJTdEJTdEJTJDJTIyaG92ZXIlMjIlM0ElN0IlMjJjb2xvcnMlMjIlM0ElN0IlMjJiYWNrZ3JvdW5kJTIyJTNBJTIyJTIzZmZmZmZmJTIyJTJDJTIybGFiZWwlMjIlM0ElMjIlMjNmZjAwMDAlMjIlMkMlMjJvdXRsaW5lJTIyJTNBJTIyJTIzZmYwMDAwJTIyJTdEJTdEJTdEJTJDJTIyaWNvbiUyMiUzQSU3QiUyMnBvc2l0aW9uJTIyJTNBJTIybGVmdCUyMiUyQyUyMmljb24lMjIlM0ElMjJmYS15b3V0dWJlJTIyJTdEJTJDJTIybGluayUyMiUzQSU3QiUyMnR5cGUlMjIlM0ElMjJsaW5rJTIyJTJDJTIydmFsdWUlMjIlM0ElMjJodHRwcyUzQSUyRiUyRnd3dy55b3V0dWJlLmNvbSUyRiU0ME9sZFN0cmVldFNvbHV0aW9ucyUyMiU3RCU3RA==
Aura inline button
summaryContact Support
paramsJTdCJTIybGFiZWwlMjIlM0ElMjJDb250YWN0JTIwU3VwcG9ydCUyMiUyQyUyMnNpemUlMjIlM0ElMjJzbWFsbCUyMiUyQyUyMnNoYXBlJTIyJTNBJTIyY2lyY3VsYXIlMjIlMkMlMjJzdGF0ZXMlMjIlM0ElN0IlMjJpZGxlJTIyJTNBJTdCJTIyY29sb3JzJTIyJTNBJTdCJTIyYmFja2dyb3VuZCUyMiUzQSUyMiUyMzI2ODRmZiUyMiUyQyUyMmxhYmVsJTIyJTNBJTIyJTIzZmZmZmZmJTIyJTdEJTdEJTJDJTIyaG92ZXIlMjIlM0ElN0IlMjJjb2xvcnMlMjIlM0ElN0IlMjJiYWNrZ3JvdW5kJTIyJTNBJTIyJTIzZmZmZmZmJTIyJTJDJTIyb3V0bGluZSUyMiUzQSUyMiUyMzI2ODRmZiUyMiUyQyUyMmxhYmVsJTIyJTNBJTIyJTIzMjY4NGZmJTIyJTdEJTdEJTdEJTJDJTIyaWNvbiUyMiUzQSU3QiUyMnBvc2l0aW9uJTIyJTNBJTIybGVmdCUyMiUyQyUyMmljb24lMjIlM0ElMjJmYS1xdWVzdGlvbiUyMiU3RCUyQyUyMmxpbmslMjIlM0ElN0IlMjJ0eXBlJTIyJTNBJTIybGluayUyMiUyQyUyMnZhbHVlJTIyJTNBJTIyaHR0cHMlM0ElMkYlMkZvc3NhcHBzLmF0bGFzc2lhbi5uZXQlMkZzZXJ2aWNlZGVzayUyRmN1c3RvbWVyJTJGcG9ydGFscyUyMiU3RCU3RA==
Aura inline button
summaryMarketplace Listing
paramsJTdCJTIybGFiZWwlMjIlM0ElMjJNYXJrZXRwbGFjZSUyMExpc3RpbmclMjIlMkMlMjJzaXplJTIyJTNBJTIyc21hbGwlMjIlMkMlMjJzaGFwZSUyMiUzQSUyMmNpcmN1bGFyJTIyJTJDJTIyc3RhdGVzJTIyJTNBJTdCJTIyaWRsZSUyMiUzQSU3QiUyMmNvbG9ycyUyMiUzQSU3QiUyMmJhY2tncm91bmQlMjIlM0ElMjIlMjM2NTU0YzAlMjIlMkMlMjJsYWJlbCUyMiUzQSUyMiUyM2ZmZmZmZiUyMiU3RCU3RCUyQyUyMmhvdmVyJTIyJTNBJTdCJTIyY29sb3JzJTIyJTNBJTdCJTIyYmFja2dyb3VuZCUyMiUzQSUyMiUyM2ZmZmZmZiUyMiUyQyUyMm91dGxpbmUlMjIlM0ElMjIlMjMyNjg0ZmYlMjIlMkMlMjJsYWJlbCUyMiUzQSUyMiUyMzI2ODRmZiUyMiU3RCU3RCU3RCUyQyUyMmxpbmslMjIlM0ElN0IlMjJ0eXBlJTIyJTNBJTIybGluayUyMiUyQyUyMnZhbHVlJTIyJTNBJTIyaHR0cHMlM0ElMkYlMkZtYXJrZXRwbGFjZS5hdGxhc3NpYW4uY29tJTJGYXBwcyUyRjEyMjA5MjUlMkZjdXN0b20tY2hhcnRzLWZvci1qaXJhLXJlcG9ydHMlM0Zob3N0aW5nJTNEY2xvdWQlMjZ1dG1fdGVybSUzRCUyNnV0bV9jYW1wYWlnbiUzREN1c3RvbSUyQkNoYXJ0cyUyQi0lMkJTZWFyY2glMkJBZHMlMjZ1dG1fc291cmNlJTNEYWR3b3JkcyUyNnV0bV9tZWRpdW0lM0RwcGMlMjZoc2FfYWNjJTNEMzQ1NzMyMzY5NiUyNmhzYV9jYW0lM0QyMDM4NzMxMjQ0JTI2aHNhX2dycCUzRDEyNzgwOTA0NjMxNSUyNmhzYV9hZCUzRDYwMTEzOTAxNTQxNCUyNmhzYV9zcmMlM0RnJTI2aHNhX3RndCUzRGF1ZC05MDA0NTY3ODc0MjAlM0Fkc2EtMTQxNzY3NjAzMjI5NSUyNmhzYV9rdyUzRCUyNmhzYV9tdCUzRCUyNmhzYV9uZXQlM0RhZHdvcmRzJTI2aHNhX3ZlciUzRDMlMjZnY2xpZCUzREVBSWFJUW9iQ2hNSXZ1cm9xY0dEX1FJVlZSUFVBUjA3ZmdRa0VBQVlBU0FBRWdMWkxmRF9Cd0UlMjIlN0QlMkMlMjJpY29uJTIyJTNBJTdCJTIycG9zaXRpb24lMjIlM0ElMjJsZWZ0JTIyJTJDJTIyaWNvbiUyMiUzQSUyMmZhLWNhcnQtYXJyb3ctZG93biUyMiU3RCU3RA==