In this page

What is Jira Misc Custom Fields (JMCF)?

(supported since Better Excel Exporter 5.1.0)

Jira Misc Custom Fields (JMCF) offers calculated (scripted) custom fields to display information based on computed values. Those result in more useful issue screens, better search, better filtering, more powerful reports and dashboards.

Jira Misc Custom Fields (JMCF) integration features

  • You can export the Jira Misc Custom Fields custom field types like Last Field Change Time, Last Field Changed by User, Parent Status, Scripted date, Scripted datetime, Scripted duration, Scripted group, Scripted group collection, Scripted number, Scripted string, Scripted string collection, Scripted user, Scripted user collection, Status Entered by User, Status Entered Time, Time In Status, Time in Status Table, Transition Count, Transition Time, Transitioned by User and Transitioned by Users to Excel.
  • Formatters are not supported.

(Need more features? Tell us in a support ticket!)

Tutorial video

Better Excel Exporter exports all your calculated (scripted) fields implemented with Jira Misc Custom Fields to Excel. (Although the video below was captured about the app's Server version, the Cloud version is very similar.)

Exporting Jira Misc Custom Fields (JMCF) data to Excel
Exporting Jira Misc Custom Fields (JMCF) data to Excel

Jira Misc Custom Fields (JMCF) Excel export samples

Issues with JMCF custom fields

Issues with JMCF custom fields

This Excel export shows custom field samples of various types, calculated by the Jira Misc Custom Fields app. For example, the "Work Started by" column contains the user who transitioned the issue to the "Under development" status the first time, while "Time in Under Development" contains the time spent in that status, and so on.

jira-misc-custom-fields-export.xlsx

Stories with the most defects report

Stories with the most defects report

In this Excel export example, a JMCF-powered custom field is used to count the bug-type Jira issues linked to the implementation sub-tasks of each user story, and store that number in the story itself. It is an indirect counter to find the stories with the most implementation defects. Another JMCF custom field stores the story owner (the user who transitioned the story to the "Accepted" status) who appears color coded to the chart.

jira-misc-custom-fields-bugs-per-story-report.xlsx

Low-effort high-impact stories report

Low-effort high-impact stories report

This Excel report uses Jira Misc Custom Fields to calculate the total vote count and the total time estimate of the tasks linked to (high priority) user stories, plus the ratio of those two. The bubble chart clearly tells which stories would create the highest value in the shortest time, i.e. which stories should be your top priorities.

jira-misc-custom-fields-low-effort-stories-report.xlsx

Configuration

Configuring the Jira Misc Custom Fields custom fields

There is nothing to do. Better Excel Exporter will automatically recognize the Jira Misc Custom Fields managed fields and export them accordingly.

Learn more about Jira Misc Custom Fields (JMCF)