How to filter on Date Closed?

Questions & Answers
1

I am trying to allow my user to be able to filter on the date range the ticket is closed (for example all tickets closed in September.

Following the instructions on this page: https://docs.eazybi.com/eazybijira/analyze-and-visualize/date-filters I made a filter based on the date closed, but when I put this report into confluence using the EazyBi Confluence Macro it does not appear on the confluence page.

image
image.png2358×892 167 KB

Is there any other way I can filter on Date Closed and make it easy for my users to select different options?

I like the Time dimension but I don’t know what the filter logic is for the time dimension or how to get it to filter on the issue closed aspect of time.

2

Hi @jeffb,

Option to Filter rows is useful in some cases if the filter may remain static. However, in your use case, it would be more convenient to set Time dimension on pages and allow users to pic periods for issue resolution.

Each measure might have a different relation to the Time dimension. To get issues that were closed in the selected period, chose measure Issues closed for your report and remove measure Issues created.

eazyBI%20Filter%20issues%20by%20close%20date
eazyBI Filter issues by close date.jpg2094×724 208 KB

More on measure Issues closed read there: https://docs.eazybi.com/eazybijira/data-import/jira-issues-import/issues-closed-measure

You may also check out 30 min training video on Time dimension and how it works with different measures: https://docs.eazybi.com/eazybijira/learn-more/training-videos

Best,
Zane / support@eazyBI.com