Eazybi column width In the image I have two columns. Jun 4, 2020 · I have a dimension that has this structure :, example: JIRA-525:Ticket Summary. eazyBI provides advanced reporting and analysis, to create anything – from simple pivot tables to multi-dimensional reports. So on an issue in Jira, this custom field might contain a string like “Zurich Jun 27, 2023 · Hello here! Thank you again for EazyBi development! I have a table showing how many Epics I have in each initiative. First is our newest formatting option, Text->Markdown (available on Cloud and starting from the eazyBI version 6. Sep 1, 2020 · In this article, I will show a few tips and tricks on how it is possible to format the measures. If you ever wonder if you are using all of the Issue Types and Issue Type schemes in your Jira and would like to find the unused ones, here’s a rather simple solution that will result in dashboards like this: Disclaimer: In instances with a large number of Projects and Issue May 31, 2019 · I have a custom field I want to import into a dimension in eazyBI. The logic is to use “Issues created” measure to find the match in the “project” dimension by the project name. Many different chart types, many data sources. 1), and second is a Custom format with which you can change the formatting of the Jan 8, 2019 · The option to format table cell values with Markdown and HTML has been added to eazyBI in version eazyBI for Jira 6. May 26, 2020 · 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. Apr 27, 2023 · In the table above I have imported data from Zypher squad and Jira and SQL I need the cycle number to be in colomns ,how can I do that ? Dec 13, 2024 · 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. Here is what I need help with. The standard total column for some reason doesn’t let you hide the symbol Jun 15, 2022 · 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. Here you will edit tables and column w Create business intelligence data reports & dashboards with an easy drag-and-drop tool. I designed a solution using EazyBI but, as long as we have the real-time data using the table view, the customer is not happy with the look and feel because he cannot change anything like text alignment, text size, etc. The individual values in my field are City, Country pairs. The “Tips and tricks” section of the eazyBI community site has some examples - Measure formatting (markdown and custom). the data I display in All Source is what I want, while the data I display in the right column is not correct. Jul 15, 2024 · Good Morning How does one create a ‘totals’ column that can be filtered when there’s multiple columns to drill into? This is also useful to display a label on the chart and be able to hide the symbol, and also where the number of rows are very high and you only want the top x number or values >100 for example. I have found the following code online that will create a column and then list the status of subtasks separated by a comma. Dec 4, 2023 · Hi there, I am new to EazyBI and am trying to create a report that has Story name as Rows and then has Number of Subtasks and Subtask status as columns. [Story Points created],[Issue Type]. Rows: Add dimensions like projects or issues here. I have a calculated time as a dimension (containing the previous week, current week and next week as columns) and time spent as Measure. May 22, 2017 · In columns, you can change measure sequence at any time by dragging and dropping them. We will be using eazyBI in JIRA-Cloud to publish several reports & dashboards on Atlassian Confluence. Jul 26, 2024 · You can drag and drop the Measures dimension in the Rows section and the dimension currently in Rows to the Columns section to achieve a view like this: Best regards, Nauris / eazyBI support May 26, 2020 · 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. In eazyBI, there are two interesting ways on how to format measures to get a different appearance. Fields that have a lot of character would simply wrap. Also, look at the eazyBI Demo account - Chart Types - Jira Demo - eazyBI Mar 21, 2022 · 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. Is there any way this can be done? Feb 13, 2020 · 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. In eazyBI, there are many ways of data filtering (using Page dimensions, filtering by name or value when you click on table headers or using MDX formulas), and I agree that it can take some effort to find the one that fits best for each report. Sep 7, 2022 · Hello @cdemez,. We get the exact data-results we are looking for, but was wondering if there is a way to alter how the table / report is displayed, in a way that would be effective for the audiences using Confluence. Assume because the string includes text other Feb 10, 2021 · Custom Jira Reports: Build useful custom Jira reports with eazyBI in minutes. 1) "Omit_Personnel" This item in red square Structure and analyze your data any way you need. Calculated measure and code below used to get comma separated list of subtasks: – generate all sub-task keys list Jul 12, 2024 · Hi everyone! 💫 For eazyBI for Jira Cloud users with Organization or Product admin rights in your Jira instance. Eaziest way is to click on the column header and use “filter rows” option:You’ll see a dialog like this: And here’s the result: Mar 15, 2018 · Hi Ajain, Sorry for the late reply! eazyBI is re-organizing JIRA data (for reporting needs), so it will not be possible to use JQL. For example, an Issue can be grouped into smaller sub-tasks. Or an Epic can be split into Stories. Pages: Use these for filters, such as selecting specific projects. Please have a look at the full list of the Jira apps eazyBI has integration out of the box on the eazyBI documentation page - Data from Jira apps. I'd like to extract the second part, but with no positive result. Jan 20, 2025 · Creating reports in eazyBI revolves around three main sections: pages, rows, and columns. That is the standard solution provided by eazyBI for your use case. I would like to filter only: Source: “January 01” Consuntivo: This column extracts the data (([Measures]. There is a workaround on how to import each column as a multi-value dimension. The sequence of dimension members (statuses, issue types, sprints etc) is set automatically. It seems simple but i cant get correct results. Feb 27, 2019 · This is more of a cosmetic issue from a Newbie. Is there any way this can be done? May 9, 2019 · Please, check the proposed solution of how you can import the Expected data as a measure and use the standard Time dimension to show the monthly Margins. On each issue, this field contains several values separated by semicolons (";"). If dimension in rows has just one project where issues are created for, this logic will know which project is that project and return it’s name in the calcualted measure. However, I want the measure to be marked True even with a column showing “Diamond,Triangle,Square”. For each column I’d like to have a different naming (for instance, first column will be “time spent”, second column will be “time planned”, so on). This dashboard might not be the most serious one, but definitely gives an overview of what is being used the most while using eazyBI and might bring some ideas on further improvements of the most Nov 8, 2023 · Hello there! I need to configure an eazyBi report with a list of epics, and epic properties in columns, and count how many stories are in each story status. Martins / eazyBI team Sep 10, 2018 · Hello, I’d like to know if there is a way to rename each column of a table differently. Is there any way this can be done? I upvoted the feature request but I can’t share any promises. with the below measure it gives me True for the columns with “Diamond”. Here is an example of what I need with excel: Do I have to create manually all measures? Is there a way to configure “nested tables” with a story report nested in my epic report? I have an additionnal problem: the pages filter should Welcome to our free and informative guide to learning Confluence from scratch for new users in small and simple steps. To reorder them, use one of the following options. Learn how to create custom reports in Jira with eazyBI. 1 - Changelog - eazyBI for Jira. I can get these values to split and import into a dimension no problem. Import All Data From Jira standard and custom fields, current and historical data, and popular marketplace apps to SQL, REST, Excel, Google Sheets, CSV, and more. Jul 29, 2023 · I need help filtering between 2 columns in my eazybi report. [Sub-Task])) and the values that will be populated in the Source field as “02 Sep 26, 2018 · Hi @jingjing. eazyBI recognizes those structures and creates different standard hierarchies in the Issue dimension: the default hierarchy with Project → Issue Jul 28, 2023 · I need help filtering between 2 columns in my eazybi report. With this example is shows false as containing “Diamond”. Is that Jun 25, 2021 · Hi team, I have a customer who is doing all the project reporting manually. Apr 17, 2020 · Currently, eazyBI doesn’t have an integration with the iDalko Table Grid Editor custom fields. Aug 9, 2018 · Does anyone know of a way to copy the cell formatting of a specific cell row or column and paste it to multiple other cells? I'm using an eazyBI table to visualize tasks per day per user, and I'm finding that I have to set the cell formatting for each user (column) or each row (date) individually. Now, i would like to count how many rows for each value… For example with this image, i would like to have a new table showing : 7 epics : 1 5 epics : 1 4 epics : 1 3 epics : 2 2 epics : 8 Is it possible? I don’t know how to do that… Thank you very much! Olivier. The “Columns” area will Mar 22, 2025 · I ask if you can help me. aqnzo zsaoqg tabszs zxcspg whhm ngcaya udw suzmvnyg syevp ehvs dkq sin hof twmeibt udfrlv