Hello everyone,
I need to create a report that shows the number of Issues with missing fields over time.
I use the time Dimension as columns.
The goal of the report is to show how or issue quality develops (hopefully it gets better )
The criteria we defined are in pseudo code:
Issuetype âStoryâ
AND issue in Status (âOpenâ or âIn Progressâ)
AND
(
issue has no assignee OR
issue has no reporter OR
issue has no component
)
I know, that I can use the Measure âIssues historyâ, which works nice e.g. for the assignee.
(
[Measures].[Issues history],
[Assignee].[(unassigned)]
)
What gives me a headache is the Component field. I couldnât make it work with the measure âIssues historyâ and I have seen some posts in the forum that an evaluation as requested by me is not possible at all, because it is a multiselect field.
I only need to know if the component field was Empty at the point in time. I donât need to know the exact component it may have had.
My question is know: Is there any workaround or âcreativeâ solution?
On the instance where I need the report we have Structure and eazyBI available.
Restrictions:
The instance is administered very restrictive, so there is no access to Automation and ScriptRunner. Also it wonât be possible to create new fields.
Thanks for your help!
Best regards
Martin