# Generating the report by status **URL:** \ **Category:** Questions & Answers\ **Created:** [April 8, 2020, 12:28pm UTC](https://community.eazybi.com/t/generating-the-report-by-status/4128 "2020-04-08T12:28:49Z")\ **Posts on this page:** 1\ **Showing post:** 2
**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:** [September 30, 2020, 8:15am UTC](https://community.eazybi.com/t/generating-the-report-by-status/4128/2 "2020-09-30T08:15:27Z")
Hi @sbandarupalli, When building a report to see changes over time, you might want to set **Time** as the only dimension on rows. Then set measures of choice and dimensions on columns. To get issue count by open and closed status in separate columns and then stacked by priority, you might order columns as shown in the picture below. ![Open and Closed issues by priority over time](https://community.eazybi.com/uploads/default/original/2X/9/9affe6f2bbea59eeef68a863cd62cd5a05e39f5e.jpeg) For an example on how to aggregate Open and Closed statuses, check out this Community post: > [@How to measure average days/workdays from transition status A to transition status B](https://community.eazybi.com/t/how-to-measure-average-days-workdays-from-transition-status-a-to-transition-status-b/1817/4): > > Hi, In this case, I would first create new calculated member in “Transition Status” dimension (which will be used for requirement a) and one also in “Status” dimension (which will be used for requirement c). Both code examples below. For “Transition Status” dimension: Aggregate({ [Transition Status].[Analyze], [Transition Status].[Clarify] }) and for “Status” dimension. Aggregate({ [Status].[Coded], [Status].[Verify], [Status].[Closed] }) For a and b requirement, then I would use the measu… Best, Zane / [support@eazyBI.com](mailto:support@eazyBI.com) --- _[View the full topic](https://community.eazybi.com/t/generating-the-report-by-status/4128)._