How to display list of issues in table

Hello

I Create a report (table ) , rows contains fix versions , but i need to displqy in column issues list of every fix version.

Could someone help me ?

Regards

1 Like

We do not suggest creating reports where you can see all issues split by all versions (or any other dimension). The reports with this setup might be hard to use and could lead to out of memory or timeout problems with a bit larger Issue and Fix version count.

If you would like to see issues in version, you can use some measure, for example, Issue created. Then you can click on the measure and use an option Drill through issues with this, you will be able to see all issues included in the Fix version.

If you would like more details on issues, you can use a list of issues un report. However, we strongly suggest using only Issue dimension on Rows and using any measure from group Issue properties to represent any value on the issue. You can use Fix version selection on Pages snd select a particular Fix version to check the details on issues. Here is a issue list report example in our demo account. You can use it as an example and add Fix Version to Pages and use it as a selection.

Daina / support@eazybi.com

Hello @daina.tupule, thanks for your help.
Is there a way to get the list of issues in a column (not as the X dimension)
I understand there can be performance concerns, but with a limited report, is there a way to do this with a generate function or other ? Thanks a lot.

You can try adding Issue dimension on Columns on your own risk. We do not suggest using Issue dimension on Columns. It might lead to serious performance issues.

The report might be hard to read (might be unusable) as well with this approach.

Daina / support@eazybi.com

Hi again @daina.tupule,

Doesn’t seem to correspond to our need (as it seems to give N columns instead of 1 per row), but I maybe wrong. Is there a way to add this with a custom measure / with generate for example (or another “concatenate” function ?
https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/mdx-function-reference/generate
e.g. we only want to display the list of issues in a single column = “ABC-1, ABC-2, ABC-3” for a specific version., instead of cumulated numbers (see Karim’s screenshot)

btw, in my humble opinion, the 2 generate examples in the documentation are very hard to understand, derivate from etc. They use other functions without links to them, and no screenshots of examples. Seeing how complex this function is, a few more examples (and simpler), screenshots and backlinks to the other functions used would be ideal.

Thanks a lot for your help.