Analyzing open tasks by component (row) and by status (column)

Question

I would like to build an report which shows components in the rows and status in columns. The value in the table should be how many issues are in status open for component xyz, how many are in status in progress, how many are in baglog, how many are done. Thank you for your help.

Mika_lfi2ur · Answer

Hi @Ilze Leite-Apine - eazyBI

thank you very much for your help!

I would like to ask if could also build a pie chart in which I show percentages of issues in a current status.

Further I would like to add a column after each status to my question before which shows the increment in the last two weeks. So that i can see how many issues changed the status from in progress to done in the last two weeks.

Thank you very much in advance!

Best regards

Mika

Ilze Leite-Apine - eazyBI · Answer

HI @Mika

In eazyBI, you can create such a report, combining "Status" and "Project" dimension Component level members together with the measure "Issues created".

You can see a similar report in the eazyBI demo account here: Unresolved issues by components and priorities.

You may change that report by selecting the "Status" dimension instead of "Priority" and using the measure "Issues created" (all issues) instead of "Issues due" (currently unresolved) in columns.

Then you get the following report.

Do not hesitate to ask support@eazybi.com if you have any questions!

Ilze, eazyBI Customer Support Consultant

Jack Brickey · Answer

Is your request specific to easybi? I note that only in your tag even listed that but not in The body of your actual post. You might consider using the two dimensional gadget on the dashboard I believe it would give you exactly what you’re looking for. However again you may be looking for an easybi only solution.