7 Replies Latest reply on May 10, 2018 10:38 AM by Jim Dehner

    Need help with JIRA - EPIC Progress Report Chart

    Imran Ahmed

      Hi Guys, I am trying to put a JIRA's EPIC progress chart together and I am getting stuck. Request is to display the planned vs. actual work in 2 separate bars. Highlight the Actual bar with red if the actual work is > 15% behind the planned work. Highlight the Actual bar with green if the actual work is within 15% range. Please refer to attached screenshot for clarification.

       

      Data Hierarchy:

      Each EPIC has multiple stories associated and each story has certain points assigned. I was able to plot based off of EPIC Link and Original Story Points / Completed Story points. I am having trouble with highlighting the Actual bar with right colors based off of calculations. I have created a sample spreadsheet for your reference. Any help will be appreciated!