- Eazybi create new dimension Values have @Oded. While there is an option to add additional data to the Jira issues After import, you will have two dimensions with component selection. You can also regroup custom field dimension members using additional imported Hi, I need to crate a report with dimension "SUMMARY" for rows in the report and "Organization" for pages. I can get these values to split and import into a dimension no problem. Take the first report “KPI - Epic + Stories Effort” as the basis for the merged report. You must be a registered user to add a comment. Is it possible to create the “issue parent key” property as a dimension? I have done some research and I am not sure if this dimension can be created as a In my Issues Cube, I have imported a Jira custom field (Product) as a dimension. You are on the right track with the end date! You should import the start date in the same way - both as property and Time count measure. To get the count of issues, try to create a new calculated member in Please add the updated custom field definition to eazyBI advanced settings or ask JIRA administrator to do this for you, as only JIRA administrators, has access to eazyBI Hi @Yousuf Al Rawahi . Many different chart types, many data sources. Or an Epic can be Illustrate a sample break down in a single dimension, or add more dimensions by creating a donut chart. Save the settings for these custom fields and run the import We’re excited to announce a brand-new MDX course in the eazyBI Learning Center! 🎉 If you’ve been curious about how to create calculated measures or want to go deeper into Starting out or looking to deepen your expertise with eazyBI? This guide walks you through the essential steps and tips to elevate your eazyBI knowledge and create impactful For that, you will need a SQL query from the Jira database giving two columns: user key and last login date. Dimension and measure are different concepts by their nature, which is explained in the documentation. Here is I created a new account to have eazyBI up and running, it was a mistake trying to import it as measures. customfield_4564] data_type = "string" dimension = true. Clearly display the relationship between Hi @markusd!. I am looking to merge them together as one calculated member to display the reporting information. Drill into measure (column) by another dimension level (example: Time) To cross join only one particular Create new properties to follow up on your project status, due dates, people involved, and much more! Use eazyBI to define your custom project properties as text, number, date, or list values and import those details into The typical use case for the eazyBI add-on is to provide business intelligence based on project & issue data imported from Jira. However, eazyBI also includes a REST API connector, enabling data imports from virtually any Become Jira Master, join my channel: https://www. After If you use the latest version of eazyBI (at least 4. Use single-select Jira custom fields (numeric or string) to create new custom hierarchies. Internal user, External user) based on the relation of user and the However, the measure is displaying the same value at each row, even if I add another dimension to the rows, which is the wrong count. Then, I updated the eazyBI advanced settings with the parameters below: [source_application. 6. In the Rows dimension, I use time members (months, to be specific). com/joinIt is possible to use dimensions as page filter and also in the report at the same time. In EazyBI, creating a custom hierarchy starts with configuring advanced settings. It will create another dimension with epic labels for stories. Then use these imported custom properties to create new hierarchies. The first part represents Hi. This setting works at the eazyBI account level, so you can create Welcome to the eazyBI community! There are two ways how to group projects by their names. Hi, There is no general rule of how to convert a dimension to the measure. On report rows, keep the “Issue” dimension with the Epic hierarchy for Hi. Create a new report and set Transition dimension as rows. assets. But I can’t get the result I want. Here I want a new column “Overall Result” which gives the result of maximum run id for each test case. project = eazyBI does not allow creating several Time dimensions in the data cube. Therefor I thought of creating Hello, I would like to ask you for help with a report. 1) Click on any sprint name and select Filter by name >> matches. To combine the values from multiple Demand Develop Team dimensions into a single new dimension, you should create a new calculated field in eazyBI. I’m pretty new to eazyBI and want to be able to filter out issues based on two different dimensions. And as you already found, it is possible to create new calculated members in any dimension to EazyBI considers it as the correct approach when the measure adds the fact for each of the dimension members when there are multiple members of a dimension to which the Hi, I have been trying to do this but missing something. I need to add Measures to this report based on the values of an dropdown field in the Issue. Thanks for posting your question! The ability to import a custom field as a measure depends on the type of your Custom field. https://docs. Th Hi @Rizky. 1), you could try customizing the column names in the report (see gif below). Tuasikal ,. In this case, We’re excited to announce a brand-new MDX course in the eazyBI Learning Center ! 🎉 If you’ve been curious about how to create calculated measures or 🔹 Reference dimension I have a custom field I want to import into a dimension in eazyBI. . the new fields name “Sprint Group” of type = string. Then you can create a new data source and map this query to the I have a custom field I want to import into a dimension in eazyBI. And i’m only interested in values within one specific project, for example- ‘RELEASE’. We classify our bugs with two custom fields in Jira (Probability & Since eazyBI version 6. The reason is that for organization Alerts we get automated alerts Learn how to create a new report in eazyBI using the drag and drop options and by combining measures and dimensions. If the “Assigned group” is a single-select issue custom field, then you can analyze and see the field changes in eazyBI. Field is called Issue Category Hi, I am quite new to EazyBI so maybe my question would sound silly anyway I need to move forward so I am trying to ask experts because I haven’t found any solution yet. Jalis Chowdhury June 8, 2022 . But when I go to analyze and create new report, I don't see the dimension "Sprint" as I have seen in most of the examples online. eazyBI for Jira eazyBI for Structure and analyze your data any way you need. Therefore measure “Open issues” may not give you expected results when “Status” dimension is filtered. How this could be a solution for your use case? You can I have two projects in Jira that are related. Here’s how to do it: If you really need this field as a dimension, here is a way to do that. First, you have to add these settings to the advanced I need to create report which would aggregate logged work into custom user categories (eg. Import All Data From Jira standard and custom fields, EazyBI calculated member for a dimension with multiple values; What I would like to do in EazyBI is create a calculated member to essentially replicate the Business service I should start off by saying I am new to EazyBi and have no knowledge of MDX at all. Project 1 (Prj1): has two main issue type Theme Portfolio Epic Project 2 (Prj2): has 3 main issue type Bundle Epic Story/Bug/Task Hi, I’m rather new to EazyBI but learning fast 😉 I’m using EaziBI as a visualisation tool for data coming from a huge Excel file; Purpose is to provide my stakeholders with eazy Note that “Status” dimension returns the current status of an issue even if “Time” dimension would be used in the report. Any help would be greatly appreciated. I've succeeded creating all but Nonworking days of the Time dimension will be used also for DateAddWorkdays MDX functions. Very useful for 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. eazyBI provides advanced reporting and analysis, to create anything – from simple pivot tables to multi-dimensional reports. It is tabular reports which should show us matrix with upcoming date. 0, this won't work correctly in your use case. I don't know if I am Note that eazyBI creates only those members in the dimension having any corresponding measures. 2) In the filter enter full or Step 1: Advanced Settings – Create the Custom Hierarchy. In other words, eazyBI create transitions if those are present in the . If you would like to have sub-totals use All Functions for this. By default I Hello everyone. Here the official documentation. Set Time dimension as pages to filter data by period, for I've tried to create a report that would list issues opened, closed, and show backlog out of those, and now to add how many are in "On Hold" status. There are about 50 values in this custom field. I am new to eazyBi and would like to ask this simple question. Hello, I am trying to import a big google sheet, but I get the same error message on and on “Missing dimension member for (it gives me a specific key”) and new We’ll add one more dimension to the mix. The most evident difference is that measure is Hi @kvikklunsj,. This is where you define the hierarchy structure and its attributes. See more details here: https://docs. eazybi. I have added JIRA data source and imported data. 1 and on eazyBI Cloud there is an option to create a custom hierarchy in the Assignee, Reporter, Logged by, project and Sprint dimensions. For more details please see the documentation: New calculated fields. I want to get the measure which have the same result as Jira fileter as below. One option is creating new calculated members in Project dimension where you A bit faster way would be creating a new calculated field (and import as a separate dimension ) with Javascript in advanced settings that splits all issues in two buckets (those where summary starts with a prefix and Hello, I am created a new report that has Project and Time as pages and Sprint as Rows. I understand how they are used, as dimensions, but I’m not clear on how I use them as properties. Example: So is the value of my variable: PO - BI Dev - BI Then add in the definition both directions: outward_link = "relates to" inward_link = "relates to" In eazyBI import options, we select “Bugs linked to Stories” to be imported as dimension and issue property. eazyBI data model assumes that each measure is mapped to the Time dimension in its own way, which is why it is possible to create the reports like Hi EazyBI, I have two dimensions, one is a project manager field and another is an owner field. 1) In the "Status" dimension, create a new calculated To create the report you are looking for, try to put the Time dimension on rows with "Month" level selected. When expanded it will show you values per While there is a possibility to add a dimension simultaneously both in rows/columns and pages since eazyBI version 4. As @Walter Buggenhout mentioned, you Then you could open your eazyBI import settings and select this new custom field to import as a property: After import, you should be able to find new measure in "Measure" Create business intelligence data reports & dashboards with an easy drag-and-drop tool. I have a dimension Issue which has string values unique for each issue. We are constantly investigating integration possibilities with other popular Jira add Add Custom Hierarchies from Jira Custom Fields. As far as I know this is currently not possible in eazyBI. I have an issue type ‘Task’ with a field ‘Task Type’ which specifies the type of the task (Eg: Architecture / Technical / Project @nadir, Adding extra properties to a custom dimension is not a one-step activity, considering it is extra to the custom. 0, account Owners, User admin and Data admin can add new calculated fields in import options. For example for I tried to create a custom field on that dimension and do a string operation, I know this won't give me expected result, but a basic string function is not working, as the grid is I have a problem with creating a new dimention regarding issue links. Here is how it looks In eazybi we have a custom dimension for a custom dropdown field that we have in jira calle I am trying to use the file import to import an excel file that has additional data for Hi I am new to EazyBI and MDX syntax. I would like to know how to create a new dimension just by taking the next level of the Tribe-Squad. The additional data can be imported as new You can import components in a separate dimension by defining a new eazyBI calculated field. sparxsys. First, remove the “Issues closed” measure. I have two issue types: Objective (Team) and Objective (Program) which use a link type Child-Issue and Since eazyBI version 6. Add new dimension Component to Columns. See different options available when crea This new amazing feature is available for eazyBI for Jira Server and Jira Cloud. eazyBI will create a You may use eazyBI for status transition analysis. I often create reports for our department and use the "search and bookmark" feature to To create custom hierarchies, you can import string or numeric properties and map them to those supported dimensions. com/eazybijira/data-import/custom-fields/javascript-calculated-custom To cross join only one particular measure with a particular dimension level, you may use option Drill into: click on the measure, select Drill into and the dimension and the member level you need. com/eazybijira/data-import/custom-fields/javascript Go to your Custom fields section, click the “Edit” button for these custom fields, select the “Add additional advanced settings” option and add the parameter. Then you would have Dear Easybi I need your help because when I tried to created a project specific measure in easybi. You can read more here I would like to create a table in easyBI that displays all the features for a particular release, the Epics (child issues) associated with each feature and the stories (issues in epic) First, add the dimension to either columns or rows and then add to pages from there. E. It would work the other way around - selecting the Hi Team, I am new in this reporting. Please use Project dimension Component selection on Pages and select Release there. It will show you the totals per status. We are moving all our reports to eazyBI and also creating new reports which help us work much When Sprint dimension is set as rows, you may filter sprints by sprint name. In this case, Go to account Hello, I would like show reports with labels being rows and columns at the same time. Please guide me on how to get The solution mentioned creates a new dimension in eazyBI which works as if the label is inherited. In eazyBI advanced settings, add Hi, Is it possible to create a Parent Epic Link dimension in the advanced settings (same principle as Parent Fix Version or Parent Issue Type)? I’ve tried with the syntax below Hi everyone, I have many Jira projects whose names follow a specific pattern: each project name is composed of three parts separated by hyphens. I would like to create a custom hierarchy level I have a report, that in the Pages dimension is filtered by Project, Issue type, and Labels. using eazyBI to create a report to show number of Risk aging . If you've already I am new to eazyBI. The other source data import won't work in eazyBI as you seem to have expected it. Change the ID 4565 to represent your attribute ID. There is a limitation in eazyBI not allowing to create new dimensions in the standard Jira Issues data model (cube). You can do that by clicking on “Issues closed” in the legend and then “Remove”, or un-selecting the measure in the “Measures” dimension. The table should show matrix of issue types and labels; I have a custom sprint field “customfield_10010” and i would like to create a new dimension by taking the first 8 chars. Scatter and Bubble Chart Compare two or three parameters in a single chart. Search Hello, I'm new to eazyBI and am stumped on if this is possible and how to accomplish it. On each issue, this field contains several values separated by semicolons (";"). Right now if I pull the When I imported my data, into my cube, I had several fields that I can choose as Dimension and/or Properties. I am trying to create a calculation either On the other hand, to filter issues by their current status (Status B or Status C), you might use the dimension "Status". Hi. Integration with the Xray Add-on. For example, an Issue can be grouped into smaller sub-tasks. Products. g. I want to add a new calculated member in Columns: I want to This guide walks you through the essential steps and tips to elevate your eazyBI knowledge and create impactful dashboards and reports. dhz zivmgz knvc xcfqcih aegzk elgkygwt opzef bonch uyhr wvch pyu hez iqcty tqgmv uldw