I am building a Power BI report with the JIRA REST API and we are trying to reach the field which holds the [ Time-in "Backlog" ] value. It's visible in the "Status Time Free" in the toolbar. Value is like this "2d 0h 31m"
Although, these columns i.e (Analysing, Backlog, Done, Funnel, Implementing, In Progress, Open) seems to be different from the other ones e.g "Key", "Summary" etc. Different in the sense that they are not in the dropdown list of 'columns' and its not possible to right-click on them to 'Sort asc/desc' as it is for e.g the "Key" and "Summary" columns.
I found something called "Time in Status" = customfield_11402 expanding that field in Power BI gives me a code that looks like this:
13011_*:*_3_*:*_507264222_*|*_6_*:*_1_*:*_0_*|*_13015_*:*_1_*:*_17536059589_*|*_10001_*:*_1_*:*_2423477339
I am not sure if this is the right one, but as I couldnt find something called "Backlog" in the filters I think this might be connected somhow. Do you know how I can proceed to find the actual time an issue have been in the "Backlog" ?
I am very thankful for any help I can get.
Best regards,
Yacob
