Custom field creation

[keerthiprashanth]

Hi Team,

Good Day.

We have created a custom report in AIO reports where it is exported to excel format. We have key columns such as End Date actual and Actual ABC date where we calculate the difference from these columns.

Is it possible to create a custom field in Jira and the final result that needs to be exported to eazyBI so that the charts can be created.

Regards,
Keerthi Prashanth S

[keerthiprashanth]

Any update on the query?

[gerda.grantina]

Hi @keerthiprashanth,
Welcome to the eazyBI community!

If you want to calculate the difference between two dates, you can use the function DateDiffDays(). If those fields are Jira datetime picker fields, import them in eazyBI and use them in your calculations.

In one other community question, I have provided the answer on how to create a measure using custom date fields that might be useful in this case too:

Time and Dates count

Hi @vryzhov, Happy to hear that you are enjoying our app The solution for counting the total service availability time would be summing the time intervals between incident start time and incident end time. As you create separate issues for each incident event for the system, you need to import the incident start and end date custom fields as properties. Then, the incident time for a specific incident ticket can be calculated using the DateDiffDays function: DateDiffDays( [Me…

Another similar answer has been provided here with detailed instructions from my colleague Zane:

Total time spent in Test Plan or Test Execution

Hi @Jonathan_Tang, In eazyBI are imported two measures Xray Tests executed first date and Xray Tests executed last date that that represent timestamp of the first and the last test run for selected test execution, test case, or test plan, or other Xray specific dimension on rows. For more details on those measures refer to the documentation: To get time between the first and the last test run for the test execution, you may define a new calculated measure using function DateDiffDays() and tho…

best,
Gerda // support@eazyBI.com

[keerthiprashanth]

Thank you Gerda for your quick response.