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. 

[Annamária SZITÁS]

Hi Joana,

How did you do that automation? I"ll try to add something like that. 

Regards,

Annamaria

[Joana Rocha]

Hi Annamaria, 

I used the fields and values directly from jira.

Here's a screenshot, hope it helps. Let me know if I can answer any question 

[Annamária SZITÁS]

Hi Joana, 

It worked :) Thank you for your help!

Regards,

Annamaria