# Number of JIRA tickets in a given status at end of each day

**URL:** <https://community.eazybi.com/t/number-of-jira-tickets-in-a-given-status-at-end-of-each-day/13065>\
**Category:** Questions & Answers\
**Created:** [July 4, 2023, 6:22am UTC](https://community.eazybi.com/t/number-of-jira-tickets-in-a-given-status-at-end-of-each-day/13065 "2023-07-04T06:22:08Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![zane.baranovska](https://community.eazybi.com/user_avatar/community.eazybi.com/zane.baranovska/32/7209_2.png) [@zane.baranovska](https://community.eazybi.com/u/zane.baranovska)\
**Post date:** [July 7, 2023, 8:33am UTC](https://community.eazybi.com/t/number-of-jira-tickets-in-a-given-status-at-end-of-each-day/13065/2 "2023-07-07T08:33:09Z")

</div>

Hi @IlliniBears,

For your report, use the measure **“Issue history”** and dimension **“Transition Status”** representing issues status changes. There is a description of mentioned measures and dimensions: [Import issue change history](https://docs.eazybi.com/eazybi/data-import/data-from-jira/import-issue-change-history).

You might want to start with the sample report “Unresolved issues by statuses over time” and modify it to your use case (it should be in your eazyBI account already in the folder “Samples Jira Issues”):  
[https://eazybi.com/accounts/1000/cubes/Issues/reports/50046-unresolved-issues-by-statuses-over-time](https://eazybi.com/accounts/1000/cubes/Issues/reports/50046-unresolved-issues-by-statuses-over-time)

Howevere, the historical values of the multi-selection fields like Component and Lable are not available in eazyBI. You can use the “Label” dimension to filter data by the **currently assigned labels** and the “Project” dimension (Component level) to filter data by the **currently assigned component**.

Here are some related topics on filtering data by Component and issue history:

> [@Grouping of components from multi projects](https://community.eazybi.com/t/grouping-of-components-from-multi-projects/1707/2):
>
> Hi, Project dimension groups components under each project, and, currently, this is the only way how components are grouped in Projects dimension. There are two ways how to get the same name components displayed as one row in the report table. Option 1. If you have a few components and this list is quite static. Then you may want to create [calculated members in the Project dimension](https://docs.eazybi.com/display/EAZYBI/Calculated+members#Calculatedmembers-Aggregatemembersinotherdimensions) for each component, where you aggregate all the same name components. Example of the formula for aggregating c…

> [@How to turn Component into a Dimension](https://community.eazybi.com/t/how-to-turn-component-into-a-dimension/5665):
>
> Would like to make component its own dimension in order to page filter

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

---

_[View the full topic](https://community.eazybi.com/t/number-of-jira-tickets-in-a-given-status-at-end-of-each-day/13065)._