How can I sort by Retention Change, not by the day the retention change takes place?

[Hannes Peterson]

In our Company Product Project, we have a label "Retention". 

The values of this label are "days" and "impact". Examples of entries would be 

"day 7 - 5%" (meaning: the number of people that churn on day 7 will decrease by 5%)

"day 1 - 2%" (meaning: the number of people that churn on day 1 will decrease by 2%)

to give you a better feeling, I attach screenshots.

values not entered

Retention Change, not set.jpg

values entered

Retention Change, set-1.jpg

Both values can be edited separately, which is great, but when i sort by "Retention", it always sorts by the day of the effect, not by the decrease. Sorting by the increase would be much more helpful.

I hope you understand and can help me solve my problem. If not, please ask.

Thank you!

[davy]

Hi Hannes

This is not possible since the sorting will always be done on the parent value.

However it is possible to do a specific search on the child value with JQL
for example: "Retention change" in ("+ 10-15%")

Hope this helps