Real Work Ratio

[Damien Syren]

Hi all !

Is there a solution to make this filter : 

realWorkRatio : (timeSpent / (originalEstimate+Remaining Estimate) x 100)

Thx

[Warren · Accepted solution]

If this is a one-off or once per sprint, you could export all issues you're interested in to Excel, with those fields as columns, then just use Excel to do the calculation

[Damien Syren]

Hi, 

Thx for your answer. I want to make this filter in order to view only over timespent tasks. I will follow this indicator every day in my daily meeting.

++

[Warren]

If you (or someone you work with) can code, you could look into using the REST API so that it can be automated. Here is the API documentation, if required

[Damien Syren]

ok thx