How to use a jira customfield type date picker as dimension

Questions & Answers
1

I have a Jira custom field (Date picker). The field is connected to a form field. I want to use this field as a dimension field time. I tried several options but didn’t found the solution.

2

Hi @Evert

There is only one Time dimension in eazyBI, and it is not supported to import date picker fields as new alternative Time dimensions (See documentation: Time dimension).

Instead, import the date picker custom field as a measure in the Jira import options. This will automatically create a measure called “Issues with ” that counts issues whose dates fall within the selected Time period. You can then use this measure together with the Time dimension to filter and group data by your custom date field.

This community post explains the setup with screenshots: https://community.eazybi.com/t/connecting-time-measure-to-time-dimension/12756/2

Best,
Zane / support@eazyBI.com

3

Dear Zane, thanks for answering. I have a calculated measure which shows all the issues with issue type ‘feedback’ in the chosen period. I want to extend the measure that all issues are shown wit issue type ‘Feedback’ and the report date in the chosen time period. is this possible?

4

I am sorry, but it is not clear what you have created and what you want to show for each period.

Suppose you want a report about Feedback issues. Start with a simple report that filters data by Issue type 'Feedback’ and represents Time periods on rows.
Then select a predefined measure that better suits your needs.

  • Issues created show how many feedback issues are created in each period.
  • Issues created show how many feedback issues are resolved in each period, regardless of when they were created.
  • Open issues show how many feedback issues are open at the end of each period
  • Issue with due date shows how many issues have a due date in the selected period (the same is for any custom date field, how many issues have the date in the selected period).

More details on each predefined measure and how it works with the Time dimesnion described in the documentation: Jira Core measures and dimensions

Feedbakc issues over time
Feedbakc issues over time1734×830 64.9 KB

Best,
Zane / support@eazybi.com

5

Hi Zane, Thanks for answering. I have solved the problem.