Compare time spent with original estimate

[Joana Rocha]

We're trying to use a jql where we compare timespent > originalestimate. This compares the field Original Estimate with the time logged through tempo.

The goal being that we set a trigger to rethink the issue when it is taking us more time than we initially planned for it. 

I get the error The value 'originalestimate' for field 'timespent' is invalid. Please specify a positive duration format; for example: '1h 30m', '2d'.

Has someone used something similar before?

Thanks! 

[Joana Rocha · Accepted solution]

Update: I've solved it by using the work ratio :) 

[Iris Barr]

Which board are you using this with?

[Joana Rocha]

Hi Iris, 

I use this for an automation, where we receive a message when the ratio is at a certain percentage (eg. 90%). 

I'm not sure I understand your question, but I can try and help.