# Questions & Answers **URL:** https://community.eazybi.com/c/questions-and-answers/7.md [Latest](https://community.eazybi.com/latest.md) · [Categories](https://community.eazybi.com/categories.md) · [Tags](https://community.eazybi.com/tags.md) --- ## [About the Questions & Answers category](https://community.eazybi.com/t/about-the-questions-answers-category/27)
**Author:** [@raimonds.simanovskis](https://community.eazybi.com/u/raimonds.simanovskis)\ **Replies:** 2\ **Last updated:** [April 24, 2018, 1:53pm UTC](https://community.eazybi.com/t/about-the-questions-answers-category/27 "2018-04-24T13:53:49Z")
Ask your questions when you need help to build eazyBI reports or import some specific source data. Do not post your sensitive information here. If you are an eazyBI customer and want to reach eazyBI support then please c… --- ## [Request for Guidance: Combining Parent and “Is Connected To” Relationships in One eazyBI Hierarchy](https://community.eazybi.com/t/request-for-guidance-combining-parent-and-is-connected-to-relationships-in-one-eazybi-hierarchy/20821)
**Author:** [@Mohssine\_ZAHRI](https://community.eazybi.com/u/Mohssine_ZAHRI)\ **Replies:** 1\ **Last updated:** [October 15, 2026, 5:00pm UTC](https://community.eazybi.com/t/request-for-guidance-combining-parent-and-is-connected-to-relationships-in-one-eazybi-hierarchy/20821 "2026-10-15T17:00:43Z")
Hi, We need your advice on a Jira/eazyBI hierarchy use case. Our target structure is: Epic → Feature → Story However, some Features currently do not have an Epic. In those cases, we use the Jira link “is connected to… --- ## [Pulling custom fields from Zephyr Scale (TM4J) Data Center into eazyBI](https://community.eazybi.com/t/pulling-custom-fields-from-zephyr-scale-tm4j-data-center-into-eazybi/5925)
**Author:** [@bar368](https://community.eazybi.com/u/bar368)\ **Replies:** 10\ **Last updated:** [October 14, 2026, 10:47am UTC](https://community.eazybi.com/t/pulling-custom-fields-from-zephyr-scale-tm4j-data-center-into-eazybi/5925 "2026-10-14T10:47:56Z")
Hi there, I am trying to create reporting for Zephyr Scale (formerly TM4J) in eazyBI. I have created a couple of custom fields for test plans (single choice dropdown, multi choice dropdown) and I would like to import th… --- ## [Report Link with Preselected Page Filter Option](https://community.eazybi.com/t/report-link-with-preselected-page-filter-option/20818)
**Author:** [@QiZhang](https://community.eazybi.com/u/QiZhang)\ **Replies:** 3\ **Last updated:** [October 8, 2026, 4:55pm UTC](https://community.eazybi.com/t/report-link-with-preselected-page-filter-option/20818 "2026-10-08T16:55:54Z")
Hi Team, We are on JIRA cloud with EZBI. Recently we are looking for a way to share report link that can preselect page filter options. This way we don’t have to create lots of same report with filter differences. Than… --- ## [In EazyBI dashboard, is there a way to hide description?](https://community.eazybi.com/t/in-eazybi-dashboard-is-there-a-way-to-hide-description/14808)
**Author:** [@Kyung\_Park](https://community.eazybi.com/u/Kyung_Park)\ **Replies:** 2\ **Last updated:** [September 18, 2026, 9:11am UTC](https://community.eazybi.com/t/in-eazybi-dashboard-is-there-a-way-to-hide-description/14808 "2026-09-18T09:11:46Z")
Hi guys, Is there a way to hide description in EazyBI dashboard? This is my report in the dashboard, but I am wondering if there is hide/expand function in EazyBI. Thank you! --- ## [Atlassian Team dimension order by team name](https://community.eazybi.com/t/atlassian-team-dimension-order-by-team-name/20816)
**Author:** [@vpurho](https://community.eazybi.com/u/vpurho)\ **Replies:** 7\ **Last updated:** [September 15, 2026, 11:37am UTC](https://community.eazybi.com/t/atlassian-team-dimension-order-by-team-name/20816 "2026-09-15T11:37:54Z")
We have started using Atlassian team (Team) in Jira and are also importing the field to eazyBI as a dimension. When using the Team in page filters, the list is not ordered alphabetically by Team name but in some other or… --- ## [Show Projects they are not in ( LIST)](https://community.eazybi.com/t/show-projects-they-are-not-in-list/20815)
**Author:** [@steinerw](https://community.eazybi.com/u/steinerw)\ **Replies:** 1\ **Last updated:** [September 14, 2026, 1:33pm UTC](https://community.eazybi.com/t/show-projects-they-are-not-in-list/20815 "2026-09-14T13:33:51Z")
I am new and need help. i import all Jira Projects into EaszBi. → they all are needed for specific Reports. Now i need a Report with all projects but without Project 2, Project5 in jira i would search like project no… --- ## [Ability for portal only customers in JSM to export a report](https://community.eazybi.com/t/ability-for-portal-only-customers-in-jsm-to-export-a-report/19025)
**Author:** [@Danilo-Simic](https://community.eazybi.com/u/Danilo-Simic)\ **Replies:** 6\ **Last updated:** [September 8, 2026, 8:07am UTC](https://community.eazybi.com/t/ability-for-portal-only-customers-in-jsm-to-export-a-report/19025 "2026-09-08T08:07:41Z")
Hello, I was wondering if there is a way to allow portal only customers to export a report that we have allowed them to view through the customer portal. --- ## [Usage statistics - Is there a way to get eazybi report on total time user spent on dashboards/accounts](https://community.eazybi.com/t/usage-statistics-is-there-a-way-to-get-eazybi-report-on-total-time-user-spent-on-dashboards-accounts/20807)
**Author:** [@Uttam](https://community.eazybi.com/u/Uttam)\ **Replies:** 1\ **Last updated:** [August 21, 2026, 1:52pm UTC](https://community.eazybi.com/t/usage-statistics-is-there-a-way-to-get-eazybi-report-on-total-time-user-spent-on-dashboards-accounts/20807 "2026-08-21T13:52:19Z")
Is there a way to get eazybi report on total time user spent on dashboards/accounts --- ## [User Role Access for creating Dashboards (eazyBI JIRA)](https://community.eazybi.com/t/user-role-access-for-creating-dashboards-eazybi-jira/8959)
**Author:** [@BrianS](https://community.eazybi.com/u/BrianS)\ **Replies:** 2\ **Last updated:** [August 7, 2026, 7:05am UTC](https://community.eazybi.com/t/user-role-access-for-creating-dashboards-eazybi-jira/8959 "2026-08-07T07:05:18Z")
We recently changed the eazyBI JIRA Role Access to make almost everyone a “User” as defined in the eazyBI documentation (see the link and image below). This was helpful because it keeps people from overwriting Reports th… --- ## [Error Blocking All Reports and dashboards in the account](https://community.eazybi.com/t/error-blocking-all-reports-and-dashboards-in-the-account/20793)
**Author:** [@NextLife](https://community.eazybi.com/u/NextLife)\ **Replies:** 1\ **Last updated:** [August 4, 2026, 2:37pm UTC](https://community.eazybi.com/t/error-blocking-all-reports-and-dashboards-in-the-account/20793 "2026-08-04T14:37:07Z")
Hello eazyBI everyone! I am writing to report a critical issue affecting one of our eazyBI accounts, ‘SW’. We are currently encountering the following error message: No function matches signature 'Sum(\ **Author:** [@swoodward](https://community.eazybi.com/u/swoodward)\ **Replies:** 5\ **Last updated:** [August 4, 2026, 8:55am UTC](https://community.eazybi.com/t/unable-to-count-total-row-in-mdx-formula-verses-getting-a-total-sum/20800 "2026-08-04T08:55:58Z") Hi, I am trying to get the total row to be a count of non empty column for each row. But I am only getting the totals to be a sum of percentages. How can I get the total row to add up the non empty columns per row? I… --- ## [Error Creating Custom Time Hierarchy: "JavaScript calculation for Jan 01 10000"](https://community.eazybi.com/t/error-creating-custom-time-hierarchy-javascript-calculation-for-jan-01-10000/20805)
**Author:** [@NextLife](https://community.eazybi.com/u/NextLife)\ **Replies:** 1\ **Last updated:** [August 3, 2026, 12:02pm UTC](https://community.eazybi.com/t/error-creating-custom-time-hierarchy-javascript-calculation-for-jan-01-10000/20805 "2026-08-03T12:02:46Z")
Hello eazyBI Community everyone! I am referencing the “Year-Month-Day hierarchy with different Month names” example from the eazyBI documentation (Custom Time hierarchies) to create a custom hierarchy in the Time dimens… --- ## [Sub-tasks not Shown in Custom Hierarchy](https://community.eazybi.com/t/sub-tasks-not-shown-in-custom-hierarchy/20791)
**Author:** [@Paul1](https://community.eazybi.com/u/Paul1)\ **Replies:** 3\ **Last updated:** [July 28, 2026, 8:08am UTC](https://community.eazybi.com/t/sub-tasks-not-shown-in-custom-hierarchy/20791 "2026-07-28T08:08:34Z")
Hi there, I’m trying to build a custom hierarchy in EazyBI Server (not cloud). It works for Epic → Story → Task. Unfortunately, Sub-tasks are not showing at all under their parents Tasks. Hierarchy: Epic → Story - s… --- ## [Import excel files but receive a dimension error](https://community.eazybi.com/t/import-excel-files-but-receive-a-dimension-error/20801)
**Author:** [@Annette](https://community.eazybi.com/u/Annette)\ **Replies:** 3\ **Last updated:** [July 27, 2026, 11:04am UTC](https://community.eazybi.com/t/import-excel-files-but-receive-a-dimension-error/20801 "2026-07-27T11:04:31Z")
Hi, I start to import an excel file. The file contains “Release” which should be inked to Fix Version/s. I receive the error : Select existing cube dimension level for “Release”, but Fix version/s is available as dime… --- ## [Administration View for import scheduled times](https://community.eazybi.com/t/administration-view-for-import-scheduled-times/9702)
**Author:** [@Marco](https://community.eazybi.com/u/Marco)\ **Replies:** 3\ **Last updated:** [July 24, 2026, 7:27am UTC](https://community.eazybi.com/t/administration-view-for-import-scheduled-times/9702 "2026-07-24T07:27:54Z")
Hello, does exists a view with the list of all accounts with import scheduled time? Thanks --- ## [Bubble chart - time vs cycle days vs number of issues](https://community.eazybi.com/t/bubble-chart-time-vs-cycle-days-vs-number-of-issues/20776)
**Author:** [@Sebastien\_RATEL](https://community.eazybi.com/u/Sebastien_RATEL)\ **Replies:** 2\ **Last updated:** [July 23, 2026, 12:37pm UTC](https://community.eazybi.com/t/bubble-chart-time-vs-cycle-days-vs-number-of-issues/20776 "2026-07-23T12:37:53Z")
Hi guys, I"'m trying to generate a cycle time bubble graph showing, for each couple of day/days in cycle, the number of issues : cycle ended days in X axis days in cycle measure in Y axis bubble size based on number o… --- ## [Customer satisfaction report to include comment and username](https://community.eazybi.com/t/customer-satisfaction-report-to-include-comment-and-username/12758)
**Author:** [@Karim\_Momo](https://community.eazybi.com/u/Karim_Momo)\ **Replies:** 2\ **Last updated:** [July 23, 2026, 8:48am UTC](https://community.eazybi.com/t/customer-satisfaction-report-to-include-comment-and-username/12758 "2026-07-23T08:48:29Z")
I would like to create a report similar to the canned satisfaction report is JSD. The report has the following fields, comment (satisfaction comment, rating, key, agents, received. Is that possible ? --- ## [Customer satisfaction report/extract to include comment and username](https://community.eazybi.com/t/customer-satisfaction-report-extract-to-include-comment-and-username/3852)
**Author:** [@aj-admin](https://community.eazybi.com/u/aj-admin)\ **Replies:** 4\ **Last updated:** [July 23, 2026, 8:46am UTC](https://community.eazybi.com/t/customer-satisfaction-report-extract-to-include-comment-and-username/3852 "2026-07-23T08:46:32Z")
I would like to create a report similar to the canned satisfaction report is JSD. The report has the following fields, comment (satisfaction comment, rating, key, agents, received. I have reviewed the Satisfaction dime… --- ## [Displaying approval and approvers of issues](https://community.eazybi.com/t/displaying-approval-and-approvers-of-issues/12977)
**Author:** [@Meytal-BM](https://community.eazybi.com/u/Meytal-BM)\ **Replies:** 8\ **Last updated:** [July 23, 2026, 8:32am UTC](https://community.eazybi.com/t/displaying-approval-and-approvers-of-issues/12977 "2026-07-23T08:32:12Z")
Hi, I want to show for issues, the people who approved/declined them. How do I go about doing that? I saw issue property “Issue Approvers”, but it just shows up as “none” values. (see screenshot) Thanks --- ## [Chart and dashboard formatting](https://community.eazybi.com/t/chart-and-dashboard-formatting/20070)
**Author:** [@Slawek](https://community.eazybi.com/u/Slawek)\ **Replies:** 2\ **Last updated:** [July 22, 2026, 11:37am UTC](https://community.eazybi.com/t/chart-and-dashboard-formatting/20070 "2026-07-22T11:37:30Z")
Hi, At the begging I’m sorry if that question was already somehow answered, maybe I’m not able to find the answer because I do not “look” for right question.. Please point me how/where and I will do my best to figure it … --- ## [Hiding Legend for Stacked Bar Graph](https://community.eazybi.com/t/hiding-legend-for-stacked-bar-graph/14169)
**Author:** [@jbran00](https://community.eazybi.com/u/jbran00)\ **Replies:** 2\ **Last updated:** [July 22, 2026, 11:34am UTC](https://community.eazybi.com/t/hiding-legend-for-stacked-bar-graph/14169 "2026-07-22T11:34:24Z")
Is there an option to hide a legend for stacked bar graphs? I currently have a dashboard with two stacked bar graphs side by side. Due to the large legend for one of them, the graph is incredibly small in comparison to t… --- ## [PDF Export does not include all the columns of Report \[A critical Limitation\]](https://community.eazybi.com/t/pdf-export-does-not-include-all-the-columns-of-report-a-critical-limitation/12861)
**Author:** [@Venkatesh\_P](https://community.eazybi.com/u/Venkatesh_P)\ **Replies:** 5\ **Last updated:** [July 22, 2026, 8:14am UTC](https://community.eazybi.com/t/pdf-export-does-not-include-all-the-columns-of-report-a-critical-limitation/12861 "2026-07-22T08:14:29Z")
Hi Team, When I export my report to PDF, it does not include all the columns that are present in the report. It omits the right most columns. I have around 13 columns but only 12 are visible in pdf. Due to this, users a… --- ## [Dashboard export to PDF ¿May we adjust page size/margins?](https://community.eazybi.com/t/dashboard-export-to-pdf-may-we-adjust-page-size-margins/19310)
**Author:** [@Luis\_Miguel\_Lopez\_Es](https://community.eazybi.com/u/Luis_Miguel_Lopez_Es)\ **Replies:** 2\ **Last updated:** [July 22, 2026, 6:54am UTC](https://community.eazybi.com/t/dashboard-export-to-pdf-may-we-adjust-page-size-margins/19310 "2026-07-22T06:54:58Z")
Hi, We have some dashboards exported to PDF or sent by email in which the margins are simply too small for the contents to fit in ¿Are there any adjustment option such as page size or margin size that can be extended or… --- ## [How to format PDF export e.g. page breaks](https://community.eazybi.com/t/how-to-format-pdf-export-e-g-page-breaks/1812)
**Author:** [@MvP](https://community.eazybi.com/u/MvP)\ **Replies:** 4\ **Last updated:** [July 22, 2026, 6:47am UTC](https://community.eazybi.com/t/how-to-format-pdf-export-e-g-page-breaks/1812 "2026-07-22T06:47:13Z")
Hi, I am currently trying to get a dashboard export to pdf looking nicely in eazyBI 4.7.3. I am surprised to see, that in the pdf export the different reports are actually cut / split / separated by page breaks. Is it … --- ## [Configure Drill](https://community.eazybi.com/t/configure-drill/7169)
**Author:** [@DEGAN](https://community.eazybi.com/u/DEGAN)\ **Replies:** 2\ **Last updated:** [July 21, 2026, 12:28pm UTC](https://community.eazybi.com/t/configure-drill/7169 "2026-07-21T12:28:09Z")
Configure Drill Hi, I’m having trouble setting up a Drill, which I need: Making a bar graph that when I call it in the grid or in Drill it brings me other fields, but if I put these fields in the graph it calls metric… --- ## [Table column name line break issue](https://community.eazybi.com/t/table-column-name-line-break-issue/20299)
**Author:** [@pea4789](https://community.eazybi.com/u/pea4789)\ **Replies:** 2\ **Last updated:** [July 21, 2026, 10:33am UTC](https://community.eazybi.com/t/table-column-name-line-break-issue/20299 "2026-07-21T10:33:22Z")
Hello, I would like to know how to prevent table column names from wrapping. Thank you. --- ## [Report Formatting](https://community.eazybi.com/t/report-formatting/3726)
**Author:** [@Shel\_Price](https://community.eazybi.com/u/Shel_Price)\ **Replies:** 43\ **Last updated:** [July 21, 2026, 10:08am UTC](https://community.eazybi.com/t/report-formatting/3726 "2026-07-21T10:08:55Z")
I would like to be able to control column width so I can have all column show on the screen without having to go to the bottom of the page without scrolling. Fields that have a lot of character would simply wrap. Is ther… --- ## [Colored Gantt Chart based on Condition](https://community.eazybi.com/t/colored-gantt-chart-based-on-condition/561)
**Author:** [@ajain](https://community.eazybi.com/u/ajain)\ **Replies:** 2\ **Last updated:** [July 21, 2026, 7:05am UTC](https://community.eazybi.com/t/colored-gantt-chart-based-on-condition/561 "2026-07-21T07:05:50Z")
Hi Q.1 How to have condition based bar color for Gantt Chart, For eg. If Target End Date is within next 30 days then Red Color, If Target End Date is within next 90 days then Yellow Color, If Target End Date is not d… --- ## [EazyBI Gantt chart](https://community.eazybi.com/t/eazybi-gantt-chart/5984)
**Author:** [@rasiak](https://community.eazybi.com/u/rasiak)\ **Replies:** 2\ **Last updated:** [July 21, 2026, 7:05am UTC](https://community.eazybi.com/t/eazybi-gantt-chart/5984 "2026-07-21T07:05:28Z")
Hi folks :slight\_smile: I just wondering that is possible to change colors assosiated with Epic statutes in gantt reports. For example right know it looks like issue with status ToDo appears on chart as blue color. The… [Next page](https://community.eazybi.com/c/questions-and-answers/7.md?page=1)