# Tips & Tricks **URL:** https://community.eazybi.com/c/tips-and-tricks/6.md?no_subcategories=false&page=1 [Latest](https://community.eazybi.com/latest.md) · [Categories](https://community.eazybi.com/categories.md) · [Tags](https://community.eazybi.com/tags.md) **Page:** 2 --- ## [Custom table of stories by epics in Jira](https://community.eazybi.com/t/custom-table-of-stories-by-epics-in-jira/14095)
**Author:** [@byrkovt](https://community.eazybi.com/u/byrkovt)\ **Replies:** 0\ **Last updated:** [October 26, 2023, 7:54pm UTC](https://community.eazybi.com/t/custom-table-of-stories-by-epics-in-jira/14095 "2023-10-26T19:54:03Z")
Hi, there is a huge board with dozens of epics which is related to all entities of our company in Jira. So, I created a custom table which represents stories with all statuses per each stream (component/label) by a few … --- ## [Import properties for Jira Assignees and build custom hierarchy](https://community.eazybi.com/t/import-properties-for-jira-assignees-and-build-custom-hierarchy/8624)
**Author:** [@daina.tupule](https://community.eazybi.com/u/daina.tupule)\ **Replies:** 5\ **Last updated:** [October 18, 2023, 7:04pm UTC](https://community.eazybi.com/t/import-properties-for-jira-assignees-and-build-custom-hierarchy/8624 "2023-10-18T19:04:49Z")
eazyBI allows importing additional properties for dimensions and creating custom hierarchies. In this example, I will walk you through how to define and import property Department for Assignee and build a custom hierarch… --- ## [Average age of issues CREATED during a time period](https://community.eazybi.com/t/average-age-of-issues-created-during-a-time-period/13156)
**Author:** [@Kristine](https://community.eazybi.com/u/Kristine)\ **Replies:** 0\ **Last updated:** [July 13, 2023, 1:59am UTC](https://community.eazybi.com/t/average-age-of-issues-created-during-a-time-period/13156 "2023-07-13T01:59:57Z")
I wanted to know average age of tickets CREATED during each quarter. I noticed the average resolution days measure is based on the resolution date, regardless of when an issue was created. I was able to create the the … --- ## [Vertical Line in timeline chart](https://community.eazybi.com/t/vertical-line-in-timeline-chart/1523)
**Author:** [@martins.vanags](https://community.eazybi.com/u/martins.vanags)\ **Replies:** 32\ **Last updated:** [March 9, 2023, 7:35am UTC](https://community.eazybi.com/t/vertical-line-in-timeline-chart/1523 "2023-03-09T07:35:46Z")
Hi in eazyBI it is possible to draw a vertical line (perhaps to visualize “today”). In order to do that, create one more calculated member in “Measures” dimension “today” that will be used as a vertical line in a chart… --- ## [Useful reports for Jira administrators from the Jira audit log](https://community.eazybi.com/t/useful-reports-for-jira-administrators-from-the-jira-audit-log/8511)
**Author:** [@janis.plume](https://community.eazybi.com/u/janis.plume)\ **Replies:** 2\ **Last updated:** [April 8, 2022, 7:23pm UTC](https://community.eazybi.com/t/useful-reports-for-jira-administrators-from-the-jira-audit-log/8511 "2022-04-08T19:23:34Z")
eazyBI data cube of Jira issues can help with some use cases for the Jira administrators but is insufficient for more advanced cases. Jira provides REST API to access the audit log records allowing the creation of many u… --- ## [Sign-up for the eazyBI Getting Started Email Course](https://community.eazybi.com/t/sign-up-for-the-eazybi-getting-started-email-course/6845)
**Author:** [@evita.legzdina](https://community.eazybi.com/u/evita.legzdina)\ **Replies:** 0\ **Last updated:** [May 17, 2021, 12:56pm UTC](https://community.eazybi.com/t/sign-up-for-the-eazybi-getting-started-email-course/6845 "2021-05-17T12:56:17Z")
If you are new to eazyBI or just looking for a refreshment of the basic concepts up to the first report creation, let us help you to get up-to-speed with the eazyBI Reports and Charts app. Now you can sign up for our get… --- ## [Agile Reporting: Additional Delivery](https://community.eazybi.com/t/agile-reporting-additional-delivery/6630)
**Author:** [@eli\_solutions](https://community.eazybi.com/u/eli_solutions)\ **Replies:** 1\ **Last updated:** [April 21, 2021, 9:58pm UTC](https://community.eazybi.com/t/agile-reporting-additional-delivery/6630 "2021-04-21T21:58:42Z")
In this Tutorial, we will go over the creation of the Additional Delivery KPI. Link to Video: https://youtu.be/\_h2uUMRRMRg Definitions: What is Additional Delivery? Measures: Sprint Story Points Not Committe… --- ## [How to Create your first Sprint Velocity Chart](https://community.eazybi.com/t/how-to-create-your-first-sprint-velocity-chart/6478)
**Author:** [@eli\_solutions](https://community.eazybi.com/u/eli_solutions)\ **Replies:** 1\ **Last updated:** [April 21, 2021, 9:51pm UTC](https://community.eazybi.com/t/how-to-create-your-first-sprint-velocity-chart/6478 "2021-04-21T21:51:19Z")
Overview In this video you can find a complete walkthrough on how you can create your first Sprint Velocity Chart: https://youtu.be/7o1-bD-H35w Tips and Tricks For Accurate Sprint Velocity Charts 1. Why are Sprint … --- ## [Dealing with Issues in Multiple Sprints](https://community.eazybi.com/t/dealing-with-issues-in-multiple-sprints/4092)
**Author:** [@rainerz64](https://community.eazybi.com/u/rainerz64)\ **Replies:** 1\ **Last updated:** [February 19, 2021, 11:37am UTC](https://community.eazybi.com/t/dealing-with-issues-in-multiple-sprints/4092 "2021-02-19T11:37:00Z")
In our JIRA system we have issues assigned to several sprints. Evaluation of those isues in general is difficult since those issues ar accounted to several sprints. In my case I want those issues to be accounted to the l… --- ## [How to change order of columns and rows in the report?](https://community.eazybi.com/t/how-to-change-order-of-columns-and-rows-in-the-report/30)
**Author:** [@ilze.leite](https://community.eazybi.com/u/ilze.leite)\ **Replies:** 8\ **Last updated:** [January 29, 2021, 3:01pm UTC](https://community.eazybi.com/t/how-to-change-order-of-columns-and-rows-in-the-report/30 "2021-01-29T15:01:46Z")
In the report columns and rows, Measures are arranged in the same order as they were added to the report. In columns, you can change measure sequence at any time by dragging and dropping them. The sequence of dimension … --- ## [General eazyBI Training Resources](https://community.eazybi.com/t/general-eazybi-training-resources/1302)
**Author:** [@janis.gulbis](https://community.eazybi.com/u/janis.gulbis)\ **Replies:** 5\ **Last updated:** [October 16, 2020, 3:52pm UTC](https://community.eazybi.com/t/general-eazybi-training-resources/1302 "2020-10-16T15:52:34Z")
Where to start? For new users and those who are new to concepts of data analytics, start with the eazyBI Tutorial Video Series (~1h total). We suggest going through all tutorial videos first, before digging deeper int… --- ## [Issue labels as property](https://community.eazybi.com/t/issue-labels-as-property/1070)
**Author:** [@martins.vanags](https://community.eazybi.com/u/martins.vanags)\ **Replies:** 1\ **Last updated:** [September 30, 2020, 7:21am UTC](https://community.eazybi.com/t/issue-labels-as-property/1070 "2020-09-30T07:21:30Z")
Jira field “Label” is being imported in eazyBI as a separate dimension out of the box, but there are cases when you would want to display issue labels (comma separated string) as the property in your eazyBI report. One … --- ## [Vacation and Capacity planning](https://community.eazybi.com/t/vacation-and-capacity-planning/667)
**Author:** [@mkvist](https://community.eazybi.com/u/mkvist)\ **Replies:** 2\ **Last updated:** [September 10, 2020, 7:35am UTC](https://community.eazybi.com/t/vacation-and-capacity-planning/667 "2020-09-10T07:35:30Z")
Our management had a request to have a capacity overview for the different teams in our department. The capacity should take into account when the different team members planned vacation or other work leave. We spent qu… --- ## [How to add Source Url for members from custom REST or SQL import](https://community.eazybi.com/t/how-to-add-source-url-for-members-from-custom-rest-or-sql-import/4954)
**Author:** [@Johannes\_Heinzl](https://community.eazybi.com/u/Johannes_Heinzl)\ **Replies:** 0\ **Last updated:** [July 30, 2020, 12:40pm UTC](https://community.eazybi.com/t/how-to-add-source-url-for-members-from-custom-rest-or-sql-import/4954 "2020-07-30T12:40:40Z")
I have asked the eazybi support for help regarding this topic and they have sent me this working answer, which i want to share with the community: It is possible to implement the GoToSource option in some cases for the … --- ## [Filter your eazyBI for last 5 closed sprints](https://community.eazybi.com/t/filter-your-eazybi-for-last-5-closed-sprints/2099)
**Author:** [@martins.vanags](https://community.eazybi.com/u/martins.vanags)\ **Replies:** 5\ **Last updated:** [March 3, 2020, 4:34pm UTC](https://community.eazybi.com/t/filter-your-eazybi-for-last-5-closed-sprints/2099 "2020-03-03T16:34:54Z")
Hi This is an approach on how to filter the report for the last 5 closed sprints if you have other dimensions in pages which makes the report context. You could adjust the code to show more/less than 5 and also switch … --- ## [Installation and Configuration of eazyBI for Jira](https://community.eazybi.com/t/installation-and-configuration-of-eazybi-for-jira/1304)
**Author:** [@janis.gulbis](https://community.eazybi.com/u/janis.gulbis)\ **Replies:** 0\ **Last updated:** [November 15, 2018, 11:22pm UTC](https://community.eazybi.com/t/installation-and-configuration-of-eazybi-for-jira/1304 "2018-11-15T23:22:18Z")
Jira Cloud Installation of eazyBI for Jira Cloud should be performed by Jira administrators. You can find and install eazyBI using Jira Plugin Manager. Search for eazyBI for Jira Cloud and click install. Jira Server If … --- ## [Basic eazyBI Concepts](https://community.eazybi.com/t/basic-eazybi-concepts/1303)
**Author:** [@janis.gulbis](https://community.eazybi.com/u/janis.gulbis)\ **Replies:** 0\ **Last updated:** [November 15, 2018, 11:11pm UTC](https://community.eazybi.com/t/basic-eazybi-concepts/1303 "2018-11-15T23:11:32Z")
Overview Data Model eazyBI is a business intelligence tool for data analysis and visualization with built-in Jira data import. We build any data cube based as a star schema. Check out about data model in eazyBI Defaul… [Previous page](https://community.eazybi.com/c/tips-and-tricks/6.md?no_subcategories=false)