Hi,
I have a JIRA structure that has themes, features, epics, tasks, spike, issue and the data is pulled over to the dashboard gadget. Currently, the gadget is only taking into those tasks that has status of "completed" or "done" and not considering other tasks that has been for instance 93% and is in progress status. Each status has its own weightage. I am thinking is it possible to calculate the average of all the progress(%) of the issue type theme level and be displayed on the dashboard? What would the JQL query be if we want to do the average function of a particular field (in this case progress) or even a sum function be to calculate the average?
