# Tips & Tricks **URL:** https://community.eazybi.com/c/tips-and-tricks/6.md?no_subcategories=false [Latest](https://community.eazybi.com/latest.md) · [Categories](https://community.eazybi.com/categories.md) · [Tags](https://community.eazybi.com/tags.md) --- ## [About the Tips & Tricks category](https://community.eazybi.com/t/about-the-tips-tricks-category/26)
**Author:** [@raimonds.simanovskis](https://community.eazybi.com/u/raimonds.simanovskis)\ **Replies:** 0
Useful examples of eazyBI reports, calculated members, data imports that you would like to share with other eazyBI users. --- ## [Issues created out of office hours](https://community.eazybi.com/t/issues-created-out-of-office-hours/180)
**Author:** [@martins.vanags](https://community.eazybi.com/u/martins.vanags)\ **Replies:** 23\ **Last updated:** [May 29, 2026, 4:27am UTC](https://community.eazybi.com/t/issues-created-out-of-office-hours/180 "2026-05-29T04:27:59Z")
There are a couple of ways how to calculate the number of issues created outside office hours. First, let us look at an example to find issues created before 9 am or after 6 pm in eazyBI. To do this, you can define a c… --- ## [Lessons from the eazyBI Book — and a Team '26 Moment That Brought It All to Life](https://community.eazybi.com/t/lessons-from-the-eazybi-book-and-a-team-26-moment-that-brought-it-all-to-life/20757)
**Author:** [@Fabian\_Lim](https://community.eazybi.com/u/Fabian_Lim)\ **Replies:** 0\ **Last updated:** [May 16, 2026, 3:03pm UTC](https://community.eazybi.com/t/lessons-from-the-eazybi-book-and-a-team-26-moment-that-brought-it-all-to-life/20757 "2026-05-16T15:03:02Z")
I just finished reading the eazyBI book on my way back from Team '26 (thanks Zane and Ilze), and it left a real impression on me. What stood out most was how the book highlights the role that culture, a tight-knit team, … --- ## [Issue Type and Issue Type Scheme usage in Jira Cloud](https://community.eazybi.com/t/issue-type-and-issue-type-scheme-usage-in-jira-cloud/17715)
**Author:** [@nauris.malitis](https://community.eazybi.com/u/nauris.malitis)\ **Replies:** 3\ **Last updated:** [January 5, 2026, 4:30pm UTC](https://community.eazybi.com/t/issue-type-and-issue-type-scheme-usage-in-jira-cloud/17715 "2026-01-05T16:30:15Z")
Hi everyone! :dizzy: :double\_exclamation\_mark: Deprecated: due to Atlassian discontinuing /rest/api/3/search API endpoint in Jira Cloud, it is no longer possible to get the count of issues for these reports. For eazyBI… --- ## [Continuing the discussion from How to reproduce Jira Control Chart “Average Cycle Time” in eazyBI:](https://community.eazybi.com/t/continuing-the-discussion-from-how-to-reproduce-jira-control-chart-average-cycle-time-in-eazybi/20477)
**Author:** [@Kelvin\_Starcode](https://community.eazybi.com/u/Kelvin_Starcode)\ **Replies:** 0\ **Last updated:** [November 11, 2025, 11:48am UTC](https://community.eazybi.com/t/continuing-the-discussion-from-how-to-reproduce-jira-control-chart-average-cycle-time-in-eazybi/20477 "2025-11-11T11:48:49Z")
Continuing the discussion from How to reproduce Jira Control Chart “Average Cycle Time” in eazyBI: --- ## [Creating Reports from Jira multi-line text custom field in eazyBI](https://community.eazybi.com/t/creating-reports-from-jira-multi-line-text-custom-field-in-eazybi/20451)
**Author:** [@valterspa](https://community.eazybi.com/u/valterspa)\ **Replies:** 0\ **Last updated:** [October 20, 2025, 8:22am UTC](https://community.eazybi.com/t/creating-reports-from-jira-multi-line-text-custom-field-in-eazybi/20451 "2025-10-20T08:22:50Z")
Sometimes you use Jira for order tracking. In a typical setup, a single Jira issue represents an order, which may contain multiple line items (such as products, quantities, prices). When order details are stored in a si… --- ## [How to create a free Training account with demo Jira data](https://community.eazybi.com/t/how-to-create-a-free-training-account-with-demo-jira-data/14043)
**Author:** [@ilze.leite](https://community.eazybi.com/u/ilze.leite)\ **Replies:** 0\ **Last updated:** [October 20, 2023, 8:28am UTC](https://community.eazybi.com/t/how-to-create-a-free-training-account-with-demo-jira-data/14043 "2023-10-20T08:28:38Z")
If you want to improve your eazyBI skills, play around with calculations or different report creation techniques and do not want to do that on your real Jira data, create an eazyBI training account with our Jira test dat… --- ## [Import issue links as dimension](https://community.eazybi.com/t/import-issue-links-as-dimension/6652)
**Author:** [@gerda.grantina](https://community.eazybi.com/u/gerda.grantina)\ **Replies:** 44\ **Last updated:** [September 18, 2025, 5:35am UTC](https://community.eazybi.com/t/import-issue-links-as-dimension/6652 "2025-09-18T05:35:06Z")
Issue linking in Jira is a powerful option and is widely used. You can import issue links in eazyBI by using advanced settings for custom fields. In this article, I will try to explain how to set up and import issue lin… --- ## [Assets: How to Import "Inbound References" in eazyBI](https://community.eazybi.com/t/assets-how-to-import-inbound-references-in-eazybi/14191)
**Author:** [@gerda.grantina](https://community.eazybi.com/u/gerda.grantina)\ **Replies:** 0\ **Last updated:** [November 6, 2023, 10:20am UTC](https://community.eazybi.com/t/assets-how-to-import-inbound-references-in-eazybi/14191 "2023-11-06T10:20:47Z")
In Assets, you can define inbound references for the objects that point from another object towards the current object. By default, eazyBI can import outbound references (the opposite direction) but does not import i… --- ## [Import fields in eazyBI from Checklist for Jira app](https://community.eazybi.com/t/import-fields-in-eazybi-from-checklist-for-jira-app/8382)
**Author:** [@martins.vanags](https://community.eazybi.com/u/martins.vanags)\ **Replies:** 36\ **Last updated:** [June 9, 2025, 4:56pm UTC](https://community.eazybi.com/t/import-fields-in-eazybi-from-checklist-for-jira-app/8382 "2025-06-09T16:56:27Z")
If you use eazyBI for Jira Data Center and wish to import custom fields provided by Checklist for the Jira app, you could find this thread useful. To import all items from the checklist field, you could use this code in… --- ## [Solving Report Mysteries: Troubleshooting report](https://community.eazybi.com/t/solving-report-mysteries-troubleshooting-report/20024)
**Author:** [@zane.baranovska](https://community.eazybi.com/u/zane.baranovska)\ **Replies:** 1\ **Last updated:** [May 23, 2025, 7:00am UTC](https://community.eazybi.com/t/solving-report-mysteries-troubleshooting-report/20024 "2025-05-23T07:00:08Z")
:information\_source: This community post is a more detailed version with many examples on Troubleshooting report data. The main purpose is to find and fix the cause if the report outcome does not match the expected resul… --- ## [Project dimension without components](https://community.eazybi.com/t/project-dimension-without-components/6451)
**Author:** [@martins.vanags](https://community.eazybi.com/u/martins.vanags)\ **Replies:** 2\ **Last updated:** [May 9, 2025, 10:19am UTC](https://community.eazybi.com/t/project-dimension-without-components/6451 "2025-05-09T10:19:25Z")
To hide the “component” level in the “Project” dimension from the report users try using data access roles to restrict eazyBI report users (user, viewer, dashboard\_viewer) from expanding Projects dimension members to com… --- ## [How to calculate Days in transition status including the time in current status](https://community.eazybi.com/t/how-to-calculate-days-in-transition-status-including-the-time-in-current-status/59)
**Author:** [@martins.vanags](https://community.eazybi.com/u/martins.vanags)\ **Replies:** 41\ **Last updated:** [April 22, 2025, 5:08am UTC](https://community.eazybi.com/t/how-to-calculate-days-in-transition-status-including-the-time-in-current-status/59 "2025-04-22T05:08:21Z")
The measure Days in transition status works for issues that already moved out from the status. Zeros might indicate an issue was moved out of the status shortly after adding to the status (or have transitioned to the sam… --- ## [eazyBI Learning Center is Here](https://community.eazybi.com/t/eazybi-learning-center-is-here/19604)
**Author:** [@evita.legzdina](https://community.eazybi.com/u/evita.legzdina)\ **Replies:** 0\ **Last updated:** [March 4, 2025, 3:05pm UTC](https://community.eazybi.com/t/eazybi-learning-center-is-here/19604 "2025-03-04T15:05:49Z")
New! eazyBI Learning Center Is Here! :tada: yesterday at 3:27 PM We’re excited to introduce the eazyBI Learning Center – a place where you can learn and improve your eazyBI skills at your own pace! :graduation\_cap: The… --- ## [How to build profit & loss report with additional data import](https://community.eazybi.com/t/how-to-build-profit-loss-report-with-additional-data-import/71)
**Author:** [@daina.tupule](https://community.eazybi.com/u/daina.tupule)\ **Replies:** 5\ **Last updated:** [July 8, 2022, 10:40am UTC](https://community.eazybi.com/t/how-to-build-profit-loss-report-with-additional-data-import/71 "2022-07-08T10:40:22Z")
Overview In this example, JIRA has custom field Cost Center and a file with a budget for each Cost Center per month. Cost calculation goes over logged hours and user rate. Users have flat rates in a seperate file. The e… --- ## [Accounts & Account Access](https://community.eazybi.com/t/accounts-account-access/1305)
**Author:** [@janis.gulbis](https://community.eazybi.com/u/janis.gulbis)\ **Replies:** 2\ **Last updated:** [February 13, 2025, 12:49pm UTC](https://community.eazybi.com/t/accounts-account-access/1305 "2025-02-13T12:49:36Z")
Planning eazyBI accounts is crucial for larger organizations. There are no technical limitations on how many issues you could have per account and it could vary a lot depending on usage. Generally we suggest not to exce… --- ## [Measure formatting (markdown and custom)](https://community.eazybi.com/t/measure-formatting-markdown-and-custom/5157)
**Author:** [@gerda.grantina](https://community.eazybi.com/u/gerda.grantina)\ **Replies:** 29\ **Last updated:** [September 26, 2023, 9:32am UTC](https://community.eazybi.com/t/measure-formatting-markdown-and-custom/5157 "2023-09-26T09:32:21Z")
In this article, I will show a few tips and tricks on how it is possible to format the measures. In eazyBI, there are two interesting ways on how to format measures to get a different appearance. First is our newest for… --- ## [Analyze eazyBI with eazyBI - eazyBI Wrapped for 2024](https://community.eazybi.com/t/analyze-eazybi-with-eazybi-eazybi-wrapped-for-2024/19243)
**Author:** [@zane.baranovska](https://community.eazybi.com/u/zane.baranovska)\ **Replies:** 0\ **Last updated:** [December 13, 2024, 9:01am UTC](https://community.eazybi.com/t/analyze-eazybi-with-eazybi-eazybi-wrapped-for-2024/19243 "2024-12-13T09:01:45Z")
Did you know that you can analyze eazyBI with eazyBI? eazyBI Wrapped is exactly that! In our “language” we call it usage statistics and it shows how eazyBI has been used in your organization. This dashboard might not be… --- ## [Monitoring you Jira like a master (eazyBI Community Days 2024 presentation)](https://community.eazybi.com/t/monitoring-you-jira-like-a-master-eazybi-community-days-2024-presentation/16972)
**Author:** [@Kondo](https://community.eazybi.com/u/Kondo)\ **Replies:** 11\ **Last updated:** [August 14, 2024, 12:58pm UTC](https://community.eazybi.com/t/monitoring-you-jira-like-a-master-eazybi-community-days-2024-presentation/16972 "2024-08-14T12:58:16Z")
Hi folks! The following attachments are the exported definitions to create the sources and the reports and dashboards to have the data configurations of Jira that were presented in the eazyBI Community Days 2024. The f… --- ## [📣Timetracker App Integration Documentation Now Available with EazyBI for Jira! 📣](https://community.eazybi.com/t/timetracker-app-integration-documentation-now-available-with-eazybi-for-jira/17753)
**Author:** [@attila.bordas](https://community.eazybi.com/u/attila.bordas)\ **Replies:** 0\ **Last updated:** [July 18, 2024, 8:28am UTC](https://community.eazybi.com/t/timetracker-app-integration-documentation-now-available-with-eazybi-for-jira/17753 "2024-07-18T08:28:17Z")
Hello EazyBI Community, We are happy to announce that our Timetracker for Jira Cloud app integration guide now available for you! The documentation provides detailed guidance on integrating your Timetracker data with th… --- ## [First transition to Transition Status (javascript field)](https://community.eazybi.com/t/first-transition-to-transition-status-javascript-field/17537)
**Author:** [@Kondo](https://community.eazybi.com/u/Kondo)\ **Replies:** 1\ **Last updated:** [June 21, 2024, 2:09pm UTC](https://community.eazybi.com/t/first-transition-to-transition-status-javascript-field/17537 "2024-06-21T14:09:30Z")
Hi folks! We had the need to develop a report that shows how many issues were transitioned to statuses in time. But it should only consider the first time that the issues were transitioned to that statuses. The solutio… --- ## [Reports by Program Increment](https://community.eazybi.com/t/reports-by-program-increment/17007)
**Author:** [@martins.vanags](https://community.eazybi.com/u/martins.vanags)\ **Replies:** 0\ **Last updated:** [April 22, 2024, 12:48pm UTC](https://community.eazybi.com/t/reports-by-program-increment/17007 "2024-04-22T12:48:08Z")
The provided use-case is possible in the scenario when using Jira Data Center with Easy Agile Programs app v6.3.0 or higher If you use both apps (eazyBI and Easy Agile Programs) you can analyze data by Program Increment… --- ## [Agile Reporting: Velocity Variance and Story Size](https://community.eazybi.com/t/agile-reporting-velocity-variance-and-story-size/6684)
**Author:** [@eli\_solutions](https://community.eazybi.com/u/eli_solutions)\ **Replies:** 6\ **Last updated:** [April 19, 2024, 1:19pm UTC](https://community.eazybi.com/t/agile-reporting-velocity-variance-and-story-size/6684 "2024-04-19T13:19:05Z")
In this Tutorial, we will go over the creation of the Velocity Variance and Story Size KPIs. Link to Tutorial: https://youtu.be/JIxDsuVoRg0 Definitions: What Velocity Variance? What is Story Size? Formulas … --- ## [How to create an additional issue hierarchy](https://community.eazybi.com/t/how-to-create-an-additional-issue-hierarchy/9793)
**Author:** [@gerda.grantina](https://community.eazybi.com/u/gerda.grantina)\ **Replies:** 15\ **Last updated:** [March 22, 2024, 11:47am UTC](https://community.eazybi.com/t/how-to-create-an-additional-issue-hierarchy/9793 "2024-03-22T11:47:27Z")
In Jira, bigger tasks can be split into smaller pieces; thus, we can create task groups that are linked together but can be worked on separately. For example, an Issue can be grouped into smaller sub-tasks. Or an Epic ca… --- ## [Import GitLab merge request information using additional REST API application](https://community.eazybi.com/t/import-gitlab-merge-request-information-using-additional-rest-api-application/2187)
**Author:** [@janis.baiza](https://community.eazybi.com/u/janis.baiza)\ **Replies:** 4\ **Last updated:** [February 22, 2024, 8:40am UTC](https://community.eazybi.com/t/import-gitlab-merge-request-information-using-additional-rest-api-application/2187 "2024-02-22T08:40:22Z")
Example REST API application definition for GitLab data import. Steps to add the application to your eazyBI: Import the following application: REST API application definition{ "application\_type": "re… --- ## [Agile Reporting: Reliability & Sprint End Spillover](https://community.eazybi.com/t/agile-reporting-reliability-sprint-end-spillover/6550)
**Author:** [@eli\_solutions](https://community.eazybi.com/u/eli_solutions)\ **Replies:** 2\ **Last updated:** [December 31, 2023, 8:15am UTC](https://community.eazybi.com/t/agile-reporting-reliability-sprint-end-spillover/6550 "2023-12-31T08:15:37Z")
Hi There, In this Tutorial, we will go over the creation of the Reliability vs Sprint End Spillover KPIs. Overview: https://youtu.be/4\_bIySkzRYY KPI Definitions: What is Reliability? What is Sprint End Spillov… --- ## [How to display number of issues in historical statuses over time?](https://community.eazybi.com/t/how-to-display-number-of-issues-in-historical-statuses-over-time/31)
**Author:** [@martins.vanags](https://community.eazybi.com/u/martins.vanags)\ **Replies:** 36\ **Last updated:** [December 14, 2023, 1:15pm UTC](https://community.eazybi.com/t/how-to-display-number-of-issues-in-historical-statuses-over-time/31 "2023-12-14T13:15:14Z")
Note that "Status" dimension returns the current status of an issue even if "Time" dimension would be used in the report. Therefore measure "Open issues" may not give you expected results when "Status" dimension is filte… --- ## [Conferences, seminars, events that are worth to attend](https://community.eazybi.com/t/conferences-seminars-events-that-are-worth-to-attend/14536)
**Author:** [@evita.legzdina](https://community.eazybi.com/u/evita.legzdina)\ **Replies:** 0\ **Last updated:** [December 13, 2023, 3:02pm UTC](https://community.eazybi.com/t/conferences-seminars-events-that-are-worth-to-attend/14536 "2023-12-13T15:02:53Z")
Hey, community! In our blog, we have shared the top 8 conferences we, at eazyBI, love to attend. We are open to new experiences and communities where all aspects of building a product, a happy team, and thriving relati… --- ## [Assets: Object filtering by a similar attribute](https://community.eazybi.com/t/assets-object-filtering-by-a-similar-attribute/14190)
**Author:** [@gerda.grantina](https://community.eazybi.com/u/gerda.grantina)\ **Replies:** 0\ **Last updated:** [November 6, 2023, 10:14am UTC](https://community.eazybi.com/t/assets-object-filtering-by-a-similar-attribute/14190 "2023-11-06T10:14:30Z")
When using Assets, there can be a situation when a similar attribute (e.g., “Owner,” “Assigned User,” etc.) is used across multiple objects. And when it comes to creating the report, the wish is to analyze all assets by … --- ## [Calculate team loading per type of request/component/label/project in Jira](https://community.eazybi.com/t/calculate-team-loading-per-type-of-request-component-label-project-in-jira/14094)
**Author:** [@byrkovt](https://community.eazybi.com/u/byrkovt)\ **Replies:** 1\ **Last updated:** [October 28, 2023, 5:23am UTC](https://community.eazybi.com/t/calculate-team-loading-per-type-of-request-component-label-project-in-jira/14094 "2023-10-28T05:23:23Z")
Hi, I prepared unique dashboard which represents all Jira activities of my team. Each team-member works on Incidents/Service requests as part of IT Help desk in Jira. Incidents and Service requests are divided per ‘lab… [Next page](https://community.eazybi.com/c/tips-and-tricks/6.md?no_subcategories=false&page=1)