Eazybi scripted field You can analyze any scripted custom fields with eazyBI. What you describe is part of the problem/solution. So this should either return the value ‘MUST-HAVE-ENG’ or True for Epics that have this Label. When using eazyBI for Jira Cloud, you could calculate the due date changes by using JavaScript calculated fields; but when using eazyBI for Jira Server changes for “due date” field can be calculated with some scripted field (e. We have such a feature request in our backlog, but I cannot estimate when and if the solution will be developed. Perhaps, a workaround is to redefine the field as single value with the following settings: separate_table=true changes=true Hi, Exposure field contains the values: 1-Critical 2-High 3-Medium 4-Low Bug can have transitions between any of these values. Some scripted fields, might not update the issue updated date when the field value is recalculated by ScriptRunner, and therefore regular data import does not import those changes. keerthiprashanth May 28, 2020, 7:03am 1. Thanks, Dhruv See Also. lauma However, it looks like eazyBI does not capture these ‘change’ date Hi As I understand it Label can contain multiple values and within Jira it’s possible to see when any of the values where changed using the History tab. You can use eazyBI advanced settings (available only to Jira system administrators, Jira trusted users, and eazyBI admins) to add support for additional Jira custom fields as well as modify It is possible to import issue Description from JIRA into eazyBI by using JIRA MISC calculated custom fields. I have already tried the solution proposed here Epics and Children with Custom Field for Epic - Questions & Answers - eazyBI Community but it did not work. Products Groups Learning Events . The custom field definition could work for eazyBI for Jira cloud when you access the custom field with ID NNNNN in the JavaScript calculation without importing it. Therefore, we recommend defining and importing those fields necessary for reports. We use lighthouse to parse it out into a property using the embeddedRegex. now I want to create a report something Keep in mind - whenever you change the advanced settings for a custom field or hierarchy, it is recommended to either do the full reimport of the data in the account or to clear the previously loaded custom field configuration (run the import with the custom field un-checked) and load it again (run the import with the custom field checked). In eazyBI, it is possible to import single-value select custom field in a separate table with value changes by adding these advanced settings to your custom field (where you place your actual custom field ID instead of NNNNN). However, the only sprint in the project is on the master board that includes issues This code will allow eazyBI to recognize this customfield as a measure, further you need to select the custom field for import in eazyBI source data import. Currently, the workaround is to use the Scripted or Calculated Jira field. Hi, I want to import LinkedIssues from Jira where the outward link = “is a key result for” I want to add it to the Custom fields import tab, but only for my account. jpg 3100×1576 524 KB. There is an option to import the Xray scripted field “Requirement Status” as a dimension in the Server and Data Center environments. The calculation is based on the stories work type which is inherited from the epic link. eazyBI uses REST API and we can access all Jira issue fields directly there, even if they are not imported. However, the solution will set the parent’s values on children no matter if a child has a value in the field or not. How can I make DateDiff between Custom Date and Resolution Date? [Measures]. Thank you , but how to count all the team members even if they not log time? I mean, in this measure i’ve got number of people from this team who logged time, but i want to know the number of the Team members regardless if they log time or not. New setup requires new data structures in a database. [Issue Standart issue picker] Click OK in the respective field dialog to apply the specified settings or create a new calculated field. eazyBI looks for issue work log entries with "Date started" within the described time period and then sums up all time spent Hi @kvikklunsj,. strojna. Example: total five issues reported for a day consider 3 issues resolved by same resolving team ‘ABC’ 1st Issue start and end time - 07 AM to 12PM - 5hrs downtime 2nd Issue - 09:00 to 15:00 - 6hrs of downtime The Target End field (from Advanced Roadmaps) shows up as a customfield for Epics but I want to access this field in Stories through js script to create another custom field. Those fields are not included in eazyBI JSON by default and those fields store the values directly in the field, not in the structure with the “value” Hi, we need to sum a calcultad field grouped by assignee, using current month and previous month like page, but we couldn’t make it work,. Hello! We have the integration with the Jira-server and implement several calculated custom fields during data import (Advance settings). 44. Indeed, measure “Issues with custom date” For Server/Data Center, you can find the solution here: Jira calculated and scripted custom fields - eazyBI for Jira Regards, Eli Solutions The alternative is to use some scripted fields in Jira where you have this calculation there. Regards, Keerthi Prashanth S. You could use this dimension to display the Issue dimension members with the respective requirement statuses, including “Uncovered”. We have 2 dimensions (Scripted fields that return issues) that contain same issues scope. I import this field as a dimension and include its value changes as well from import configuration. You were right, I did not perform See more about these measures here Import issue change history - eazyBI for Jira. Then you can access the summary from a scripted field issue using this formula in calculated measure: CASE WHEN Not IsEmpty([Measures]. CurrentHierarchyMember}, [Measures]. Perhaps, you could try using calculated Jira fields to check if the field was changed or not and then import the scripted field directly in eazyBI. Your assistance is greatly appreciated. We had a similar problem, when the scripted field was at one level (Story), but was calculated based on another You can analyze any scripted custom fields with eazyBI. ( [Measures]. You can check the custom field ID in Jira and see the ID in eazyBI with hower: image 1808×1404 246 KB Our JIRA Issue has a company field indicating the companies affected by this issue. When using scripted fields you can import changes for Due date field and use in eazyBI report. Save the changes then go to the Hi @mikes222,. I need to get by project in a given specific issue type the TotalPurchase value, if there are Hello, We have two custom fields to track start and end date of a Jira Issue. The app also supports extending this and inheriting values from a specific level of the hierarchy during import. To import a custom field as a measure in EazyBi you need to : 1. cirule, I’ve followed your steps and when we started the import process, after having imported about 7. The JavaScript code will modify the issue JSON object before importing issues we have a custom scripted field in jira and we’re importing it into an eazyBI account as a dimension and property. What I want is to obtain the TOTAL of initial budget, final and availibity. Hello, I am creating a new cube using custom fields as dimension. In “Rows”, we have Is it possible to create a custom field in Jira and the final result that needs to be exported to eazyBI so that the charts can be created. Jira Misc or ScriptRunner) With the help of this scripted field, each issue would get the first assignee during the data import when the field is defined in advanced settings. My import settings for both fields look like this, and it seems the data arrives just fine in the cube. Run an import to get a Hi, I am new to eazyBI, so apologies in advance if my question is very basic, but couldn’t find similar topics. anitu May 3, 2021, 8:25pm 1. eazyBI, by default, allows data to be analyzed based on the issue field values. If the “Assigned group” is a single-select issue custom field, then you can analyze and see the field changes in eazyBI. Kindly, Hi @DanteBRSP,. More examples on how to import Scripted fields you will find in the link @Gustavo Félix shared. Zdenek July 23, 2024, 3:00pm 7. You can check the custom field ID in Jira and see the ID in eazyBI with hower: image 1808×1404 246 KB Hi, I have custom field Expected, wich is a date field. They might not work if using Jira Misc Custom Fields version 2. x. customfield_NNNNN] data_type = "text" Then you could open your eazyBI import settings and select this new custom field to import as a property: Save the Advanced settings, go to Source Data tab, deselect the “Initiative Owning Team” field from import and run import without it (to clear the old structure and values of the field. If you would like to import Jira custom fields then go to tab Custom fields [2] [3] or tab Add-ons [1] to import custom fields specific to Jira apps eazyBI has integration with [1]. eazyBI looks for issue work log entries with "Date started" within the described time period and then sums up all time spent Epic name is a field only for epic issues and it is automatically imported as issue property "Issue Epic Name" when custom field "Epic Link" is selected for data import. Hi If the field is redefined with data_type = string from advanced settings, you could try import it as dimension with value change history but this would work only for single-select custom fields. I want to get a count of a specific issue type that has a combination of labels. malikgp August 27, 2018, 3:35pm 5. Unfortunately, Issue link field dimensions that are used to filter data by upper level issue valuses, do not work with Project dimension, including the Component level. eazyBI looks for issue work log entries with "Date started" within the described time period and then sums up all time spent I would like to know if there is a way to get the change history of the CheckBox field through a script in Advanced settings. CurrentHierarchyMember), [Time]. Send them to support@eazybi. In eazyBI, we can have a report showing the number of issues by the Next, you could open your eazyBI advanced settings and add these lines where you place your field ID (the 5digit number from URL of your custom field) instead of NNNNN [jira. At first, you need to find out Jira custom field ID. I would like to a) Need help in creating a calculated metric - a count of these fields example : Issue ABC-123, company id: apple, microsoft, google , count = 3 Issue DEF-458, company id : null ( empty) , count = 0 issue XYZ-232, company id: eazybi , count = 1 b) Is it possible to Epic name is a field only for epic issues and it is automatically imported as issue property "Issue Epic Name" when custom field "Epic Link" is selected for data import. I need to calculate the number of USs that exist under epics which have specific values that are being selected in the page section. In other words, the issue picker field must be of single-issue picker type at the child issue, which seems not to be your case. We have created a custom report in AIO reports @martins. Basically, I want to see how much of the issues are automated over time because the issues themselves are not necessarily automated right away. I would suggest checking the values in property Issue Priority In Jira we use a number of Risk field including the above, along with: Initial Consequence rating Program Risk Category Enterprise Level Risk Residual Consequence Rating etc. First is our newest formatting option, Text->Markdown (available on Cloud and starting from the eazyBI version 6. Let me know if this works as expected! Best regards, Nauris Note that this code expects that the custom field has the customfield_lua as the ID. We do have a change request on the backlog, however, I can’t promise any release dates for it. Let me know if you need any further assistance with this! Lauma. ewa November 30, 2020, 9:00am 3. But MDX always confuses me. grantina December 10, Dear eazyBI team, I would love to have a change history for Java Script calculated fields. cacus. For example by issue shows 168. customfield_XXXXX] measure = true . In this case, you should define your new calculated custom field via eazyBI advanced settings. Count members of Tempo Team. eazyBI looks for issue work log entries with "Date started" within the described time period and then sums up all time spent Hi, In this case, you could try using eazyBI advanced settings to define your custom field as a dimension for eazyBI data import (by replacing XXXXX with your custom field ID) [jira. Scripted field does not need to be displayed in the Issue screen, but it can be imported to eazyBI as a dimension. The script might look They are a performance risk. Yes, I have configured the custom field in Advanced Settings. cirule. Sum({PreviousPeriods([Time]. [jira. Imported measures and Unfortunately, you are correct - eazyBI does not import the due date changes by default. Scenario 1. For example, some time Tasks with sub-tasks or Epics don’t show a calculated score at all. I want to do the same with easyBI but can’t figure out if the D Please Have a look at this field with yellow color I cant Import it using Java script or Jira its bult on field I also dont know the type of it ? eazyBI Community How to Import Zypher sqad field I have tried java script but it ia faild Note: Above criteria(in script) for business hrs should be applicable still for my request. If you need to add additional source applications in eazyBI for Jira Hi @Amzad , It appears that you are using JavaScript custom field “Last date when custom field changed” from the eazyBI documentation. Martins / eazyBI support With the help of this scripted field, each issue would get the first assignee during the data import when the field is defined in advanced settings. "Our Team" to "Team 1" because we added another Scripted Field Definition. check the step 1 from my previous answer in this thread. 14 1271×100 54. Label 1 and Label A Scenario 2. The option is available in eazyBI for Jira Cloud and starting from version 6. Hi Dear Forum, I have followed the online help and looked how to import a custom scripted field which is working well. It may also happen that changes in this field are not imported with the incremental data import if the issue is not updated otherwise. Description by default is a long text field that is rarely used to store quantitive values that could be analyzed. Hi Team, Any update on the above request? Please help me ASAP. Then you can aggregate the values by creating a calculated member in that dimension. com for more details. 0. 5, but the report is showing 169. We have a change request in our backlog, but I can’t promise any release dates. You also need to re-import all issues if any dimension members (for example, statuses, priorities, or custom field select list values) are renamed. Unfortunately, worklog field items can not be imported in eazyBI cube if you use Tempo and Jira Cloud combination to log hours in Jira. The same code would give limited results for the Jira Server since the change history is accessible to a limited extent in the eazyBI for the Jira Server app. One thing you can try is to get the information in a scripted field in Jira and then try to import it in eazyBI. Label 1 and Label B Hi, I have a custom field in JIRAit is a selection list. e. Next, hover with the mouse over its entry and then I have a single select custom field that is imported into eazyBI. Some data problems might not stop the import, but they will display in Mapping to single value custom field dimensions. The value is calculated properly in the custom field (it has After updating the eazyBI advanced settings, you can select the "Import value changes" option for this custom field together with the "Dimension" and "Property" options. Add the parameters below to your eazyBI advanced settings: Would you recommend created a scripted field in Jira for Priority2 and mapping it into eazyBI or doing a Javascript field in eazyBI directly, so we don’t crowd our Jira DB with extra, confusing fields? The MDX solution sounds perfect, but I don’t “see” how I would implement it in eazyBI. You can consider using some scripted fields in Jira with more extended and complicated rules to inherit values from parent issues. You can use only one time zone in each eazyBI account. I had to change the text/name of one of the field options, e. Please see the documentation on how to do this and for the code example: Import issue change history Go to Hi @DanteBRSP, Regular data import, imports change of updated issues since the last data import. I would suggest checking the values in property Issue Priority Dear eazyBI team, I would love to have a change history for Java Script calculated fields. [value 3] [customFiled]. Then, using However, in eazyBI, you might want to create a new JavaScript calculated custom field that would process the Summary content and group all issues with a specified keyword in summary; the rest of the issue would be marked with (empty) In eazyBI advanced settings, add the code to group issues by text in the Summary field. However, you may import Epic Name also as a separate dimension using advanced settings. The limitation is that eazyBI cannot build a hierarchy if the child can have several parents. On closing an issue, we add the reason for closure. customfield_XXXXX] data_type = "string" dimension = true multiple_values = true split_by = ',' After that you could select to import (via Jira import options) it as a separate dimension Hi, By default, eazyBI does not import project change information from Jira. eazyBI removes these surrounding white spaces for custom field values during Jira data import and writes in the log file which customfield and which value was adjusted. The TestRunStatus custom field is a scripted field. And perform data import. The scripted field To add custom field import options, head to the eazyBI import option "Custom fields" tab [1] and find the desired custom field in the list [2]. Thanks in advance. I had noticed some other advice that seems illustrate a means to use Java Script to point If you need to change a default custom field settings in a single eazyBI account, you can edit the custom field import options in the specific account. Jira Misc or ScriptRunner) Use custom field ID instead of NNNNN in the definition above. How can I import this data? You could define how the scripted field should be imported into eazyBI. Please export and share the definition for your eazyBI report: Export and import report definitions. Then you eazyBI can precalculate new fields using JavaScript and based on available data. Please double-check and provide full JS codes for all four measures if the statuses are correct. ; eazyBI Blog - to keep up on the actualities about eazyBI, recent product releases, customer Unfortunately, eazyBI can’t import the change history for the Insight object type of custom fields. Martins / Hi Team, When a Sprint is closed the value this field is changed to Dropdown values and when we check this field name was jira. We have used custom ordering of this string using Calculated Members. I’m using the following code: Issue link Hi Team, I am new to eazyBI reports, Need your help to create a report which can fetch test case count by each Product team Below are the details which can help you understand my Jira setup and eazyBI import Jira project: Name: Testing Board Each team will create story and sub-tasks to capture key parameters in this Jira project Below are the field captured in The configuration with the scripted field would require a couple of more steps. vanags If you are maintaining the Epic Yes, you are correct. eazybi can import changes for some default fields (Status, assignee, priority, issue type) but not for all fields. Go to "Advanced Settings" tab. . If you When you say creating an Epic Assignee group in a scripted field are you suggesting a scriptrunner scripted field in Jira or a javascript field in eazyBI? Thanks. How can we get cumulative “issues created” for the same string value? Thanks, Vrukesh However, there migh be different selections in Jira import options how the custom field is selected for import in every eazyBI account. See more details on how to do that here - JavaScript calculated custom fields - eazyBI for Jira. For this reason, eazyBI does not import issue description by default. I need a way to show the amount of times a Date field was changed/updated from its original Date. global calculated field. You won’t need any custom advanced settings to import date picker field as measure. Hi @Raphael_Teodoro_Silv. Or sometimes the Task gets the score of all sub-tasks * 2 (in the above example: ab = AVERAGE(ba,bb) *2) The calculation that I showed is done in the calculated field in script Hi Team, When a Sprint is closed the value this field is changed to Dropdown values and when we check this field name was jira. Users can open source data Jira import options for edit and select the custom field for import using any required options (in this case, story points, as dimension, measures, property, and value changes). But please share more details about your field and perhaps a screenshot from Jira how exactly do you enter values in your scripted field. And select custom fields you would like to import. For fields imported using Javascript in advanced settings or Jira scripted fields, it won’t be possible to have a history imported in eazyBI. Best, Ilze , support@eazybi. 1), and second is a Custom format with which you can If the eazyBI for Jira app does not start up, check Jira memory settings to see if there is enough JVM memory available. Yes, if component is set only in Epic level, the report shows data only from epics themselves if the report is filtered by components. eazyBI supports additional data import to single-value custom field dimensions with one level. I need to import some economical data from an sql source. When building the Javascript code it is very important to All custom field calculation formulas mentioned in the examples below are supported by Jira Misc Custom Fields version 1. Add custom field definitions to eazyBI advanced settings. The function workdays will calculate workdays from two dates: The default Team custom field should be the one that is shown in the Advanced Roadmaps section. grantina December 10, The situation hints that you might have copied the script but have not updated the status values in the JavaScript code used or have not changed the variable or field names in the scripts. vanags do you have a modified script for this? martins. Hi, eazyBI cannot track the history of multiple value fields, like checkbox. In this case how can i list all the issues with the history of the due date change. Pedriel July 4, Hi, By default, eazyBI does not import project change information from Jira. So I need a count of how many “Issue Type = Enhancement” have. How to choose In this case, you should define your new calculated custom field via eazyBI advanced settings. gerda. eazyBI Community Portal for real-life use cases and solutions. I’d like to return values by time and user dimension. Unfortuantely, we do have only one example on Structure boards to illustrate this approach: If “Reason for Blocking” is a single-select custom field in Jira you can import history for the field in eazyBI. vanags If you are maintaining the Epic For example I will have Custom Date custom field similar to your documentation. Here is an example with a custom field ‘T-shirt size’ I have imported changes to: [Issues_-_eazy There is a difference in eazyBI for Jira cloud. I’ve selected Add new calculated field and in the popup Welcome to the eazyBI community! The best solution, in this case, would be retrieving this numerical part of the string in a separate numeric custom field and then import it as a measure. I would like to create a bar chart that totals stories closed or totals story points closed by month with each work type a separate column in a bar chart. [Transitions to issues count], [Transition Field]. just the time dimensio Go to eazyBI advanced settings, and add settings to specify expected data_type for scripted custom field. g. For example, you can see a list of linked issues and their status or other properties. In Jira, you can display data based on computed values to support any number of uses cases. How can we do it? Thanks in advance, Custom field data import. Import the field to find the date when a Jira custom field (which is also imported in eazyBI) was changed the last time for a specific value. I have looked at the Custom Field area for import, but they do not show up there for import. Jira scripted custom field with multiple dimensions Questions & Answers calculatedmembers , multiple-dimensions , scripted the epic from those issues has a custom field called MPC type and the field is set Time dimension . From what we discussed here, it would be similar Hi, I’m trying to script a multi-dimensional field but cannot quite get it to show values in the report table. Hi @Marcelo_Ignacio_Cid1,. 1 Like. The time zone of the Time dimension will be used to determine the date member in the Time dimension when importing issue measures (e. Actually, I think I read somewhere, that it’s not possible for fields calculated with JMCF, and I guess it’s not possible for Java Script calculated fields either. martins. They do not appear in the custom field list to be imported into EasyBI. When I want to It would be awesome if there was a free-text field available where I can describe this purpose and is also shown in the lists of sources Cheers, // Svante. Please have a look at a use case where the history of “Original estimated hours” is imported via a Jira Misc custom field - https: Hi, Am a newbie trying to learn EazyBi features. Our Epics have features, and features have user stories. is you field “Test Automation Status” a scripted field? If so, the change history is not going to be available for scripted fields. Custom field name "UR ticket ID This contain the Jira id of issue present in XYZ project. Hi @grandeau! I am sorry for the delay in getting back to you about this! Unfortunately I do not have good news as eazyBI does not allow to create a user group dimension for other than default user-picker fields. See an example below: How to generate report in EazyBi based on how many time a due date has been changed in an issue type. I want to use the Advanced settings: New calculated field. Is any possible to associate wit You can analyze any scripted custom fields with eazyBI. You need to create the scripted field in Jira for capturing the author of the last update there. My report is going to shine thanks to you. Martins / I’m trying to create a report in EazyBI for Jira but have been unsuccessful. [value 1] [customFiled]. It is good to hear you found a solution on your own. See the linked post for an example of the sum of empty values - Getting a count of issues that do not have a given link - #2 by roberts. [Issue]. Also, Next, you could open your eazyBI advanced settings and add these lines where you place your field ID (the 5digit number from URL of your custom field) instead of NNNNN [jira. com. So in EazyBI I have some values like this [customFiled]. [value 2] [customFiled]. Is there any feedback on how to create it ? Thanks a lot for your suggestion. However, there are a couple of caveats for this in your case: Epic name is a field only for epic issues and it is automatically imported as issue property "Issue Epic Name" when custom field "Epic Link" is selected for data import. Best, Hi, We have created custom field with type string for displaying created week number relative to milestone, and use javascript code to fill it up and display along with “issues created”. racobaldo April 3, 2023, Solution provided by Martin can not be applied because my field is a multi-value field. Finally, head to the eazyBI import options, select the newly defined JavaScript calculated custom field for import, and make sure all the referenced custom fields are imported as well. Please find here the example of how to do that with Jira Misc or Scriptrunner custom fields: I tried with following code. The situation hints that you might have copied the script but have not updated the status values in the JavaScript code used or have not changed the variable or field names in the scripts. As a workaround, you could create a calculated field that checks if the issue does not have a description, return 1. ; Let's get started videos - introduction to the eazyBI basic concepts, first report creation and publishing with the eazyBI for Jira app. You can consider using For example I will have Custom Date custom field similar to your documentation. Since the Team field is not available for import from JIRA Cloud into EazyBI, I am trying to find a way to infer that value – possibly using the [Sprint][Board] structure. Workdays. As workaround I used my own scripted field (provided by ScriptRunner) in order to flag ticket in which my field assumed that value (ChangeHistory supported me in order to perform that check). The filters include the following 2 dimensions: [Target PI] and [Label] I have written the following measure to check based on Instead, we would recommend moving all the scripts to one custom field definition (one JS) and then using just the outcome in the new field. eazyBI does not have native integration with the Structure app. It’s a workaround which probably does not work in a lot of cases, but for us it does. After the import finishes, select this field for import and run the import again. After, that you should be able to see your custom field in the custom field list where you can select it and then import in eazyBI as the property for an issue. grandeau July 14, 2020, 1:07pm 3. I’m using the following code: Issue link field dimensions - eazyBI for Jira. A JavaScript Calculated custom field called ‘Must Have Eng’ that is either a single value subset of Jira field ‘Label’ on Epics OR a True/False field. custom date imported in eazyBI. You could use advanced settings to change the definition for the custom field and change the output format so it can be imported with levels in eazyBI dimension. Just using multiple_dates (i. we suggest using some scripted fields in Jira to track changes for some Labels to support some specific scenarios. Get issuelinks as customfield using java script. Usually, when I want to extract a text out of a sentence, I use substring and Charindex Example: Start “Extract this text” End I would write : SUbstring (text, Charindex(“start”, text) + 6, Charindex (“end” , text) What’s a possible way to do so in javascript to create a custom field? Regards The default Team custom field should be the one that is shown in the Advanced Roadmaps section. It is more complex for testing in this case. customfield_NNNNN] data_type = "text" @Swapna_R. Measure, on eazyBI side, has There is no such dimension in eazyBI currently. 6. Go to import options; the Scripted field should now be visible in the tab Custom fields. Please add an additional separate_table = true parameter to the custom field definition in the import options (see picture below) or in eazyBI advanced settings if the custom field is relevant to all eazyBI accounts. That can result in report performance problems. It depends on the field. lauma Hi, Your guide was perfect. 2. in eazyBI i have imported this custom field as dimestion and property. It Epic name is a field only for epic issues and it is automatically imported as issue property "Issue Epic Name" when custom field "Epic Link" is selected for data import. It is possible to import it by using Jira calculated or scripted custom fields; see more details here: Jira calculated and scripted custom fields. 000 issues it gave us the following Also, ensure that the project (for issue picker from selector field) is also imported in eazyBI. You can import the custom field as a dimension. I have eazyBI configured with Jira. If script gave you empty results, likely the field is is not imported correctly. jira, dataimport. The principles and advanced settings importing Jira Misc fields into eazyBI are the same for all Jira Misc app version. I amb using the following custom fields as dimension in the Source Aplication JIRA: After importing the issues from this JIRA account I obtain the following cube I can filter properly the measures using those two dimensions. You can specify the time zone [1], the first day of the week [2] and non-working days [3] [4] of the Time dimension. Then, using Hi @sanjeevnarula. Field “Closed Reason” can be “Software”, “Hardware” etc. click on the settings icon (the cog) in the upper right corner of the app. Thanks!! eazyBI Community Sum custom field grouped by assignee. 3. However, although it does show as decimal in EazyBI, it has auto round the field. Still, I hope you have a solution meanwhile 🙂 Best regards, Jan If you use eazyBI for Jira Data Centero and wish to import custom fields provided by Checklist for the Jira app, you could find this thread useful. lazaruk,. So , here is the scenarios. It deals with combinations of multiple Labels. Have you followed to the Source data import tab to select the import of dimension I have a Project in a JIRA Cloud instance that has multiple boards organized using the “Team” field from Portfolio. By default the custom fields are filled with (-1). Although, I don’t recommend defining such broad calculated members in the Issue dimension. You would like to delete old ones and then create new data . Jira Misc or ScriptRunner). customfield_10005 so use the Custom field import concept with below code for importing into eazyBI. Then import both as measures in eazyBI, and, after the data import, you would get a measure Calculated field with Hi @Tania. [Country] ) This would give the total count of transitions to the specified dimension members. Regular data import, imports change of updated issues since the last data import. In eazyBI advanced settings, add settings for the issue custom field “Assigned group” to enable the import of value changes. Select them and import them as dimensions and/or properties for “Issue” dimension members. eazyBI supports only some default measures based on workdays. You can check the property with Not IsEmpty() for filled values. janis. The main goals for calculated fields are: improve report performance; organize data in a new way based on available data; On this page: Account specific vs. One script == 1 additional custom field Is it possible to create an array (i. In Jira I have multiple projects with different issue types that have different custom fields. You can really do While eazyBI stores timestamps of status changes, such calculation in eazyBI side would be complex and very slow. M,. customfield_NNNNN] data_type = "text" Unfortunately, importing the Environment field from Jira is currently impossible in eazyBI for Jira Data Center. hroch February 19, 2019, 2:29pm 3. Hi @lauma. Then provide your SEN and current scripts you tried so far. Is there a way to display these values without Then the best approach would be inventing JavaScript calculated custom field that, during data import, goes through each issue changelog and retrieve days for the last assignee; it would be something similar to the already mentioned Days for assignee scripted custom field. eazyBI Community For this example to work, you need to use a scripted field of the Scriptrunner add-on accessing the By default Issue description field is not imported to eazyBI. Revathy0227 January 4, 2022, 11:14am 3. Preparation. The simplest option would be asking for parent field value if the issue does not have one on the report with a list of issues in within a specific hierarchy: CoalesceEmpty Hi, Exposure field contains the values: 1-Critical 2-High 3-Medium 4-Low Bug can have transitions between any of these values. Custom fields are available in Jira import options: go to the tabAdd-onsto choose and import custom fields specific to Jira apps I have two custom scripted (Scriptrunner) fields in JIRA. I want to compare the “Estimated EndDate” values entered in the story at the end of each sprint, but the table below only shows the most recently entered value. We are using excel for this today with a lookup of the Our JIRA Issue has a company field indicating the companies affected by this issue. When you say creating an Epic Assignee group in We also have a scripted field, which calculates a risk “score” from those two fields, which we will need to reproduce for eazyBI since scripted fields history cannot be imported to eazyBI. You should provide the additional setting for the import of such field so that the incremental import would re-check all the values Solved: Hello, i am trying to get the historical values of a custom field in scriptrunner. When having lots of source applications it is quite hard to see what the purpose of each Hi there We are using eazyBI with JIRA. Add the updated custom field definition to eazyBI advanced settings or ask Jira administrator or eazyBI administrator to do this for you. See also: eazyBI documentation The TestRunStatus custom field is a scripted field. And select either individual checkboxes (Import as a dimension, Import as a measure, Import as a property, or Import value changes) I would like to create a calculated field using Project dimension. U pdated custom field definition could be used in eazyBI advanced settings if function setNumbers is defined as common javascript function. I also create a “availablity” field. data_type="string" dimension="true" seperate_table="true" changes="true" Question, why did this script add the field “Hosting2”, “License Type2”, “Status2”. customfield_10005] data_type = “string” dimension = true Once this code is imported not able to get these values in Import There is a Scripted Field from ScriptRunner Addon, when importing the field in eazyBi, the updated value does not come for it Even when re-importing the value does not updates. 00. eazyBI Community Description in the JIRA Import. In eazyBI, there are two interesting ways on how to format measures to get a different appearance. My intend is to find out if and how jira saves these. Insert the following lines . Lauma / support@eazybi. Perhaps, you could try using calculated Jira fields to check if the field was changed and then import the scripted field directly in eazyBI. Without historical Hi, It is possible to create the hierarchy from the issue picker fields in eazyBI with specific advanced settings. For the teams which have written something inside "Deliverable ID", we have a Scripted Field "Status" which is going to define the issues' status. We have registered this in eazyBI backlog, and I “Estimated EndDate” is a custom field that contains an estimated completion time for when the story will end. In eazyBI you can use some MDX formulas. Calculated custom fields are pre-calculated just once during data import and then saved in the eazyBI By default, eazyBI does not import custom fields; you have to select which fields you will need for your reports. This is because you imported two new fields filling in values with one script. On Atlassian Marketplace you can find several Jira apps that let you create calculated custom First, you should import both custom fields as measures (in eazyBI import options, section Custom fields select option Import as measure). customfield_10005] data_type = “string” dimension = true Once this code is imported not able to get these values in Import Hello I have two projects ABC and XYZ on ABC project issue there is customfield multiple issue picker available. com Hi Digby, The advanced settings you have posted here look correct, including the issue_id_column. lazaruk, eazyBI does not have native integration with the Structure app. svante November 27, 2019, 12:55pm 1. You would like to see new names in eazyBI. We would like to create a report based on Original Estimates Days that is able to create a flat workload on the duration of the issue regarding the mentionned start date and end date. When building the Javascript code it is very important to Hi @Fred. Feature Requests. plume May 25, 2023, 7:36am 2. The only solution I can think off is creating a scripted custom field “Moved from” in Jira (using Jira Misc custom fields, for instance) and precalculate, from issue changelog, project change information in this field (for instance, in format “1, Project A, 2018-04-20”) for each issue. Hello Martins, thank you for your reply. It could have an impact in Jira, though. I just updated our documentation page. Here is a custom field definition example, that overrides default setup for string field: I have a imported and synced a scripted field according to this guide, where my values are long HTML tags which renders to coloured tags within Jira. However, if you can populate the folder name for each issue using scripted custom field in Jira, then you may import that custom field in eazyBI (Jira calculated and scripted custom fields). I can build the Javascript code from scratch but I can also modify an existing script that eazyBI team has published on the documentation page or in one of the community posts. When I tried the script in the link, it gave me different values for the last sprint I changed. [Issue Standart issue picker]) THEN [Issue]. Hi @aswinir,. it could be done either in Jira, using some scripted custom field, or during data import in eazyBI, using JavaScript calculated custom field. This action enables a custom field for data import. Hi @rohit. Once you have a link dimension specified, you can use it’s id in the definition. 8 KB Martins / eazyBI team. Regards, Revathy Madhavan. Did you use your actual custom field ID instead of NNNNN? Does it work if you import the field as property with data_type = “text”? [jira. Then you could re-use the same formula to calculate the value for the new field. GetMemberByKey( [Measures]. It All available custom field names are shown with a Projectrak prefix (to ensure that names do not overlap with the standard and custom Jira issue fields). We are using excel for this today with a lookup of the Hi @Raphael_Teodoro_Silv. eazyBI advanced settings are common for all accounts and only Jira/eazyBI administrators have access to the settings. I have adjusted the precision and scale attributes, but unfortunately this does not correct the issue. You can also define the change history import for other Jira custom fields, but they must be defined with data_type = “string” and they should be single-select fields (only one value per issue). I would like to a) Need help in creating a calculated metric - a count of these fields example : Issue ABC-123, company id: apple, microsoft, google , count = 3 Issue DEF-458, company id : null ( empty) , count = 0 issue XYZ-232, company id: eazybi , count = 1 b) Is it possible to Hi @Amzad , It appears that you are using JavaScript custom field “Last date when custom field changed” from the eazyBI documentation. When I build a report with time In eazyBI, you can define additional rules to create new dimensions from linked issues and new Issue hierarchies and modify data during data import. eazyBI Community Custom field creation. [Issues with Custom Date] returns only if the issue have the value filled but not the actual value. If I add the “total” row, I get the results (at the end of the report) but i have to expand all the projects. Unfortunately, the value change import of scripted custom fields is not available in eazyBI because value changes of those custom fields are not represented in issues history. Hi Team, Good Day. You should provide the additional setting for the import of such field so that the incremental import would re-check all the values Hey everyone I have a solid T-SQL background. Hi, i’m trying to get the “issuelinks” as custom field and I didn’t succeed. In such cases we suggest precalculating this information in Jira, using some scripted field (e. Instead of importing your date picker Jira field as a separate dimension, it should be enough to import it as a measure and property , and then use the numerical measure "Issues with " with the “Time” However, in eazyBI, you might want to create a new JavaScript calculated custom field that would process the Summary content and group all issues with a specified keyword in summary; the rest of the issue would be marked with (empty) In eazyBI advanced settings, add the code to group issues by text in the Summary field. If Number or Duration custom field is imported as a measure then this measure name will end with sum (Projectrak number custom field sum) and will show the total sum of this custom field for projects. The custom field script doesn't write to the ticket history - it just updates the value so it makes sense that the time reference on import into eazyBI, in this situation, is always the ticket creation date, regardless if that value is calculated x 1000 times. The value is calculated properly in the custom field (it has several values in the selected issues) Hi @lauma. I’m trying to create a report in EazyBI for Jira but have been unsuccessful. Ask the community look at an example Next, you could open your eazyBI advanced settings and add these lines where you place your field ID (the 5digit number from URL of your custom field) instead of NNNNN [jira. For more details see those topics: Import issue links; Additional Issue hierarchies; Issue link field dimensions; Custom JavaScript code; Hi EazyBI Community, I have a report request that have multiple scenarios. The script might look Please Have a look at this field with yellow color I cant Import it using Java script or Jira its bult on field I also dont know the type of it ? eazyBI Community How to Import Zypher sqad field I have tried java script but it ia faild To avoid creating too many custom fields we use a table in the description field. [Issue Container Story Points] ) Could you please help to fetch & import that custom field in eazybi to generate the report with that custom field URL’s or external links. eazyBI Community Add Description field to Source Applications. @martins. I would like to set Time dimension based on value from this field. customfield_NNNNN] data_type = "text" Then you could open your eazyBI import settings and select this new custom field to import as a property: @Swapna_R. vanags added this to eazyBI backlog based on your request some time ago and I upvoted this request again, but no estimates for now. Hi, I have a field named Automation Status in jira issues and its a multi select. I have all these projects with an initial budget and a final value. You should provide the additional setting for the import of such field so that the incremental import would re-check all the values Hello, Thanks for your answer ! Unfortunately, I still have some troubles trying to apply : Jira calculated and scripted custom fields - eazyBI for Jira I created a pre calculated field “free_field_date_01 timestamp changes” how do i create a custom field which during import will check the values of 2 issue fields and store a boolean value based on the result of the condition. Thanks @Janis Plume _eazyBI_. The field only appears on a single issue type but across all create a new calculated field specific to the particular eazyBI account with new calculated field, or you can define calculated custom fields using JavaScript in eazyBI advanced settings as described further (and then they will be available Yes, I have configured the custom field in Advanced Settings. eazyBI cannot import the history of the scripted fields. Scripted field finds the Position list of all linked Stories or Requirements. Currently, only able to get the current Here are some posts on how you can import some structure-specific data into eazyBI: You can also check if you can define and import links and build issue hierarchies that also might help with structure data analysis. Hi, we have a custom scripted field in jira and we’re importing it into an eazyBI account as a dimension and property. And Hi @Tania. We want to chose in one page dimension and get in second page dimension the same value automatically in order not to choose twice (because there are 2 different measurements). But the due date changes due to some dependency. Unfortuantely, we do have only one example on Structure boards to illustrate this But keep in mind that each additional field imported in eazyBI increases the size of the data cube. Actually, I think I read somewhere, that it’s not possible for field I found a solution for the history of string values as well. You can check the custom field ID in Jira and see the ID in eazyBI with hower: image 1808×1404 246 KB Unfortunately, you are correct - eazyBI does not import the due date changes by default. With XXXXX values being the id of your custom field . If you don’t have the option to create a new custom field in Jira, define a new JavaScript calculated custom field in eazyBI. customfield_NNNNN] data_type = "integer" dimension = true. eazyBI automatically detects custom fields during data import. Example: Project Name Value AA XXX 3 AA XYZ 4 AA ZYZ 5 BB XXX 2 BB CBA 3 BB MNC 2 Desired Output: IF Poject name STARTSWITH (“AA”) THEN “Alpha” IF Poject name STARTSWITH(Project,“BB”) THEN “Beta” Project Name Value Alpha 12 Beta 7 Can any one Hi @Mauro_Bennici,. You can see the custom field ID when you hover over the custom field name in the eazyBI import settings. Your requirement requires two new calculated measures - one for “true” and one for “false”. I need help. customfield Hello, I have a question because its not clear for me. The same I’d like to have for fields calculated with JMCF. fabio. The only workaround is to implement the creator field as a scripted field in Jira and then import this field as a new dimension. Select the field and import data. So at the bottom of all the Custom Fields I like to add that field as a Calculated Custom field. Now as I can see, Time dimension is based on date create issue. of Time in Status level members except member You can use custom JavaScript code in the eazyBI account to modify Jira issues field values during import. Unfortunately, eazyBI can track changes only for single-value fields. Click [2] Save to keep the Hello @xavi. In “Pages’”, we have added “Closed Reason”, and highlighted Select members -> “All Closed Reason”. -s. In order to do that, at first, you could create a new JIRA MISC We are using a scripted fields in some reports on Eazybi through the following advanced Setting: The fields is imported as a dimension and as a property. ; Training videos on specific topics - various training topics for different user levels. That could be the limitation in your use-case. If these fields were already in the data source (“Hosting”, “License Type”, “Status”)? Снимок экрана 2022-12-20 в 13. The result we find is something like this. best, Gerda // support In this article, I will show a few tips and tricks on how it is possible to format the measures. eazyBI Community Ability to create groups dimensions from any user field. You can define a calculated member in this dimension where you Aggregate all members of the No. In eazyBI, you can analyze numeric field changes over time if the custom field data type is integer or decimal, and its value changes are stored in the issue changelog. If a Due date was created 1/1/2019 but pushed out 3 different times and is lastly showing 6/1/2019, I need the report to show the number of times it was changed, 3 being the answer. vanags February 17, 2020, 9:04am 3. To avoid creating too many custom fields we use a table in the description field. I want to do the same with easyBI but can’t figure out if the D How to generate report in EazyBi based on how many time a due date has been changed in an issue type. Daina / support@eazybi. Martins / eazyBI team. [value n] This custom filed is in a row report and I would like to show only the value witch have the caracters XXX for example. I want to make it behave like the “Sprint Story Points at closing” value, but I can’t do that with the If a custom field value ends with white space, it is not visible in the eazyBI dimension member and can cause a hard-to-trace data mismatch. 0 or later because of changes in Jira Misc functionality. Create . Once done editing eazyBI import options, click [1] Import to save changes and start the data import right away. We support extending this and inheriting values from a specific level of the hierarchy during import as well. Martins / eazyBI. Goals: - Have a column displaying the # of distinct "Deliverable ID" value, per teams By default Issue description field is not imported to eazyBI. Martins / eazyBI support. To import all items from the checklist field, you could use this code in your advanced settings: (use Jira custom field ID instead of NNNNN in following codes) Unfortunately, eazyBI can’t import the change history for the Assets object type custom fields. eazyBI by default allows analyzing data if the issues themselves have specific field values. Additionally, for checking the custom field type, please verify that through Jira issue settings The default Team custom field should be the one that is shown in the Advanced Roadmaps section. I made one change that I thought I’d share. Questions & Answers. , hard coded or make one additional API call to get some additional data) and use this created array for all scripts? please, could you explain it? or any Error: Field present in Issue screen: Advance Settings script: NOTE: I have used datatype as string, text, integer & date but still it throws below error! Kindly help us to import date field as dimension. These doesn’t render in Score does a simple numeric calculation that populates a custom script field that I created (Number Searcher type). You might want to add a new parameter check_calculated_value = true to the An alternative solution is to have some scripted custom field in Jira, that captures changes of specific labels and then import that scripted custom field in eazyBI along with the change history of it. The approach with the multiple user picker Hello We are using Eazy bi for reports in Jira Data Center. Revathy0227 December 9, 2021, 4:53am 2. Currently, only able to get the current A JavaScript Calculated custom field called ‘Must Have Eng’ that is either a single value subset of Jira field ‘Label’ on Epics OR a True/False field. i have also imported ABC and XYZ data in same cube. So I changed the script to the following and it worked fine. You can reach out to support@eazybi. #The name of your custom field here [jira. Indeed, measure “Issues with custom date” Hi, @Revathy0227 , There can be only one date/date-time dimension in the eazyBI “Issues” cube, and there is already a “Time” dimension with that data type out-of-box. customfield_NNNNN] data_type = "text" Could you please help to fetch & import that custom field in eazybi to generate the report with that custom field URL’s or external links. Add parameters similar to the one below to your eazyBI advanced settings: [jira. Issues created, Issues resolved and others) The Jira Components field is a multi-value field. You should use a json_fields = [“customfield_NNNNN”] parameter in the custom field definition to address a custom field NNNNN in the calculation without importing it. Say i have an issue type, defect and the defect would be set with a due date and a fix version. See the eazyBI documentation page for more details about JavaScript calculated custom fields - JavaScript calculated custom fields. When I import this field into eazyBI the values are not imported correctly. Best, For Server/Data Center, you can find the solution here: Jira calculated and scripted custom fields - eazyBI for Jira Regards, Eli Solutions Unfortunately I do not have good news as eazyBI does not allow to create a user group dimension for other than default user-picker fields. Here are a few observations and suggestions: Tracking the last change date: The JavaScript custom field, as its name suggests, is designed to track the last date when a custom field value was changed to a specified value. We want to count number of specific value of “Closed Reason” over time interval. You might want to add a new parameter check_calculated_value = true to the On each "Sub-work" issue type, I'm having a field "Deliverable ID" in which teams can write something, or not. njk pmlvjdu vxqwg zgdyek givmpwc uvcba pwbas rxjkbb lbrclvg nqttiq