# Project + Component Report

**URL:** <https://community.eazybi.com/t/project-component-report/17456>\
**Category:** Questions & Answers\
**Created:** [June 11, 2024, 9:53pm UTC](https://community.eazybi.com/t/project-component-report/17456 "2024-06-11T21:53:31Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Elizabeth\_Jones](https://community.eazybi.com/user_avatar/community.eazybi.com/elizabeth_jones/32/9497_2.png) [@Elizabeth\_Jones](https://community.eazybi.com/u/Elizabeth_Jones)\
**Post date:** [June 11, 2024, 9:53pm UTC](https://community.eazybi.com/t/project-component-report/17456/1 "2024-06-11T21:53:31Z")

</div>

I want to create a matrixed report of components. For any given project I would like to show a table that is a matrix of all issues with component = usability and then the other components applied to that issue and a count. I am able to do this with native jira report (see screen shot) but am struggling to recreate this in EazyBi.

 ![Screenshot 2024-06-11 at 3.51.05 PM](https://community.eazybi.com/uploads/default/original/2X/7/7c62ac2b6005eca0ec226586e6b03d9373ed492a.png)

How do I create a column dimension that lists components so that the matrix or 2-dimensional view can be created?

 ![Screenshot 2024-06-11 at 3.53.08 PM](https://community.eazybi.com/uploads/default/original/2X/0/008c91ecfce1b53b751809629d857cbbb69e6c68.png)

---

<div class="post-metadata">

**Author:** ![roberts.cacus](https://community.eazybi.com/user_avatar/community.eazybi.com/roberts.cacus/32/637_2.png) [@roberts.cacus](https://community.eazybi.com/u/roberts.cacus)\
**Post date:** [June 14, 2024, 9:11am UTC](https://community.eazybi.com/t/project-component-report/17456/2 "2024-06-14T09:11:42Z")

</div>

Hi @Elizabeth_Jones,

For a matrix report, eazyBI requires another _Component_ dimension. I recommend defining a new JavaScript calculated field for that. Please see an example here - [Dimension Component as filter - #4 by zane.baranovska](https://community.eazybi.com/t/dimension-component-as-filter/7834/4) and here - [JavaScript calculated custom fields](https://docs.eazybi.com/eazybi/data-import/data-from-jira/jira-custom-fields/javascript-calculated-custom-fields#JavaScriptcalculatedcustomfields-Component).

After that, you can use the _Project_ dimension in report rows and pages. The new _Component_ dimension in columns. The report could look similar to the one below:

 ![SCR-20240614-kysk](https://community.eazybi.com/uploads/default/original/2X/9/9b12519d20f83daf01e269672eb4f0510be7253c.png)

One additional problem that will arise with “Open issues” is when adding the “Total” rows and columns. The total will add all issues, where the total of both rows and columns will be a sum of values instead of the actual issue count. This tends to happen with multi-value fields. I recommend defining a new calculated measure to retrieve the distinct count of open issues. The formula could look similar to the one from the following community post - [Open issues for a suset of components - #2 by roberts.cacus](https://community.eazybi.com/t/open-issues-for-a-suset-of-components/6874/2).

With it, the report could look slightly different in the “total” department:

 ![SCR-20240614-kzkg](https://community.eazybi.com/uploads/default/original/2X/c/c2612008abe7b2bf5f64c901480f2c9da60eb624.png)

Best,  
Roberts // [support@eazybi.com](mailto:support@eazybi.com)

---

<div class="post-metadata">

**Author:** ![Elizabeth\_Jones](https://community.eazybi.com/user_avatar/community.eazybi.com/elizabeth_jones/32/9497_2.png) [@Elizabeth\_Jones](https://community.eazybi.com/u/Elizabeth_Jones)\
**Post date:** [June 18, 2024, 6:52pm UTC](https://community.eazybi.com/t/project-component-report/17456/3 "2024-06-18T18:52:35Z")

</div>

Thank you; works great!
