I am currently creating a straight table chart comparing a developer's 'dev % burn' and their 'dev % complete'. In order to get an idea of what a developer's 100% complete or the burn rate would be, I divided dev % burn by dev % complete in an expression. Unfortunately I have to calculate dev % burn during an expression and it is not currently a field in my script because it is coming from two different excel sheets.
I am getting the actual time spent from tracker and dividing it by the estimated efforts to get dev % burn. Dev % complete is already a calculated field so it is just divided by the dev % burn afterwards.
I use background colors in order to distinguish which is 'red, yellow or green'.
The burn rate coloring goes as follows:
- If the burn rate is less than 85%, it is red
- If it is 85%-89%, it is yellow
- If it is 90%-110%, it is green
- If it is 111%-115%, it is yellow
- If it is greater than 115%,it is red
I need a way to either to create the burn rate in the script or I need to be able to create a button using the set analysis expression. The button needs to be able to identify which is red, green or yellow.