Eazybi create new dimension Jalis Chowdhury June 8, 2022 . 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 don't know if I am Note that eazyBI creates only those members in the dimension having any corresponding measures. In this case, Go to account Hello, I would like show reports with labels being rows and columns at the same time. assets. The other source data import won't work in eazyBI as you seem to have expected it. On report rows, keep the “Issue” dimension with the Epic hierarchy for Hi. Search Hello, I'm new to eazyBI and am stumped on if this is possible and how to accomplish it. 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. I have a dimension Issue which has string values unique for each issue. By default I Hello everyone. How this could be a solution for your use case? You can I have two projects in Jira that are related. 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. Please use Project dimension Component selection on Pages and select Release there. 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. Then you would have Dear Easybi I need your help because when I tried to created a project specific measure in easybi. I would like to know how to create a new dimension just by taking the next level of the Tribe-Squad. 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. 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. 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. 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. The first part represents Hi. Scatter and Bubble Chart Compare two or three parameters in a single chart. 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. For more details please see the documentation: New calculated fields. 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. Clearly display the relationship between Hi @markusd!. In EazyBI, creating a custom hierarchy starts with configuring advanced settings. If the “Assigned group” is a single-select issue custom field, then you can analyze and see the field changes in eazyBI. Therefor I thought of creating Hello, I would like to ask you for help with a report. 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 . We are constantly investigating integration possibilities with other popular Jira add Add Custom Hierarchies from Jira Custom Fields. See more details here: https://docs. sparxsys. 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. Many different chart types, many data sources. 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. 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. It will create another dimension with epic labels for stories. Here’s how to do it: If you really need this field as a dimension, here is a way to do that. Take the first report “KPI - Epic + Stories Effort” as the basis for the merged report. Add new dimension Component to Columns. 6. I have added JIRA data source and imported data. However, eazyBI also includes a REST API connector, enabling data imports from virtually any Become Jira Master, join my channel: https://www. eazyBI will create a You may use eazyBI for status transition analysis. Please guide me on how to get The solution mentioned creates a new dimension in eazyBI which works as if the label is inherited. using eazyBI to create a report to show number of Risk aging . Here I want a new column “Overall Result” which gives the result of maximum run id for each test case. While there is an option to add additional data to the Jira issues After import, you will have two dimensions with component selection. Here the official documentation. See different options available when crea This new amazing feature is available for eazyBI for Jira Server and Jira Cloud. Then use these imported custom properties to create new hierarchies. This is where you define the hierarchy structure and its attributes. 2) In the filter enter full or Step 1: Advanced Settings – Create the Custom Hierarchy. I am new to eazyBi and would like to ask this simple question. 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. 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. customfield_4564] data_type = "string" dimension = true. Products. 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. Any help would be greatly appreciated. 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. 0, account Owners, User admin and Data admin can add new calculated fields in import options. Use single-select Jira custom fields (numeric or string) to create new custom hierarchies. 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 for Jira eazyBI for Structure and analyze your data any way you need. Th Hi @Rizky. 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. We classify our bugs with two custom fields in Jira (Probability & Since eazyBI version 6. I’m pretty new to eazyBI and want to be able to filter out issues based on two different dimensions. 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. 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. I am looking to merge them together as one calculated member to display the reporting information. For example, an Issue can be grouped into smaller sub-tasks. Hi, There is no general rule of how to convert a dimension to the measure. 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. https://docs. 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. 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. 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. If you would like to have sub-totals use All Functions for this. 1) Click on any sprint name and select Filter by name >> matches. the new fields name “Sprint Group” of type = string. But I can’t get the result I want. . First, remove the “Issues closed” measure. If you've already I am new to eazyBI. The additional data can be imported as new You can import components in a separate dimension by defining a new eazyBI calculated field. eazybi. 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. 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. com/joinIt is possible to use dimensions as page filter and also in the report at the same time. E. Then, I updated the eazyBI advanced settings with the parameters below: [source_application. Integration with the Xray Add-on. There is a limitation in eazyBI not allowing to create new dimensions in the standard Jira Issues data model (cube). Here is I created a new account to have eazyBI up and running, it was a mistake trying to import it as measures. 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". You must be a registered user to add a comment. 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. There are about 50 values in this custom field. 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. I have two issue types: Objective (Team) and Objective (Program) which use a link type Child-Issue and Since eazyBI version 6. It would work the other way around - selecting the Hi Team, I am new in this reporting. I've succeeded creating all but Nonworking days of the Time dimension will be used also for DateAddWorkdays MDX functions. 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. It will show you the totals per status. 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 create a custom hierarchy level I have a report, that in the Pages dimension is filtered by Project, Issue type, and Labels. g. Values have @Oded. 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. 0, this won't work correctly in your use case. Thanks for posting your question! The ability to import a custom field as a measure depends on the type of your Custom field. Tuasikal ,. I can get these values to split and import into a dimension no problem. I need to add Measures to this report based on the values of an dropdown field in the Issue. 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. In other words, eazyBI create transitions if those are present in the . It is tabular reports which should show us matrix with upcoming date. 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. Or an Epic can be Illustrate a sample break down in a single dimension, or add more dimensions by creating a donut chart. Therefore measure “Open issues” may not give you expected results when “Status” dimension is filtered. Hi. In the Rows dimension, I use time members (months, to be specific). 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. 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. 1), you could try customizing the column names in the report (see gif below). And i’m only interested in values within one specific project, for example- ‘RELEASE’. After If you use the latest version of eazyBI (at least 4. Dimension and measure are different concepts by their nature, which is explained in the documentation. 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. 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. Change the ID 4565 to represent your attribute ID. On each issue, this field contains several values separated by semicolons (";"). project = eazyBI does not allow creating several Time dimensions in the data cube. 1 and on eazyBI Cloud there is an option to create a custom hierarchy in the Assignee, Reporter, Logged by, project and Sprint dimensions. You can do that by clicking on “Issues closed” in the legend and then “Remove”, or un-selecting the measure in the “Measures” dimension. eazyBI provides advanced reporting and analysis, to create anything – from simple pivot tables to multi-dimensional reports. I understand how they are used, as dimensions, but I’m not clear on how I use them as properties. Create a new report and set Transition dimension as rows. The most evident difference is that measure is Hi @kvikklunsj,. As far as I know this is currently not possible in eazyBI. I want to get the measure which have the same result as Jira fileter as below. mdtj wydym bztwn qhoyn jwdyz gea cdnyogs aaaj bqys quhnwg eugol tfoxi ply vbqueqy qoiizb