I received a request from a customer to report on historical data of a select list.
There is a single select list field “Team” with two values: KS and SMB. The value of the field is based on which team is currently responsible for the work on the issue.
The customer asks for following statistics:
- report on timestamps or duration in the issue, when the value changed (or how long there was the specific value in the issue). This is very similar to the SLA-feature.
- the list of issues where the original value was KS and has been changed in the process to SMB.
I looked at several topics (e.g. https://community.atlassian.com/t5/Jira-Core-questions/Eazybi-custom-field-changing-over-time/qaq-p/456402?tempId=eyJvaWRjX2NvbnNlbnRfbGFuZ3VhZ2VfdmVyc2lvbiI6IjIuMCIsIm9pZGNfY29uc2VudF9ncmFudGVkX2F0IjoxNTk5NTUwNjUyNTI3fQ%3D%3D) but it didn´t work.
Can you help me with this? Is it possible at all to create such reports?
Thank you in advance.