Eazybi issue history. This is a radio-button field in jira.
Eazybi issue history return “Issues history” measure instead of number 1 for overdue issues (one place, at the end of code) Aug 5, 2020 · In that case, you need to use a different formula to count “Issues history” with “Transition Status” aggregates. In this case how can i list all the issues with the history of the due date change. So for example show all tickets which in week 48 where in one of the status A, B or C. I will post here when something new appears. Issues history <Custom field> history: Issue history counts issues assigned to a sprint at the end of the selected time period. Jul 2, 2020 · Having those status history as dimension and so forth is a prerequisite, then use Transition Status dimension together with measure Issue history. But what I would actually need is for the report to show only issues created between two weeks ago and today. The chart is done daily so we can’t modify Sep 10, 2020 · We have a custom field called “Invoice Type” to indicate whether or not an issue is chargeable of nonchargeable and some other options. , number of issues with the selected issue type or priority in a particular time period), use those dimensions (Issue type or Priority) in the report together with the measure Issues history and the Time dimension; then you will get the count of issues with the selected issue Jun 3, 2024 · Bonjour tout le monde, I’m making a graph to display the history of tickets to do, in progress and finalized. I tried some solutions but did’t get what I was looking for. I also don’t seem to be able to find issues that have estimates (which would let me do some subtraction Oct 1, 2019 · 2019/01/02 = 10 issues (5 issues with due date set on 2019/01/02 and the 5 overdue issues aforementioned) Well, we are now on 2019/02/01 and for any reason I modify the 5 overdue issues on 2019/01/02 to 2019/03/01, I need that the result for “2019/01/02” remains 10 because in this day was 10 overdue issues and I have reported that to my Mar 12, 2018 · Hi, I currently have the following setup: Columns: Measures - Issue History and Transition Status - several statuses. Sep 25, 2019 · My client need to knows how many times a subtask estimation data change and why. I can’t use the Sprint Story Points added measure, because our users sometimes create issues by duplicating others, and Jun 28, 2024 · Adding the issue history to it adding a bit more complexity. “A” was first assignee, and made “B” new assignee. - the number Nov 12, 2018 · Hi @erichard00. [Issues history] - ( [Measures]. Thus I recommend you display its value disregarding the Time dimension. To display a number of issues in historical statuses over time, we recommend importing issue change history (via eazyBI import settings). Do I have to use something different than Assignee? If May 3, 2021 · See more about these measures here Import issue change history - eazyBI for Jira. That will retrieve you the historical status of the issues for each Time period, use this tuple in Measure dimension to create a calculated measure : Nov 4, 2021 · Is there any way to show the issue change history in a log list mode, and highlight the key changes. jingjing,. The possible causes for such behavior might be as follows: importing user does not have access to all issue changelog records, May 20, 2020 · Hi, I have the following configuration: -> Columns: Measures (Issues History) ; Status (Category) -> Pages: Project (All projects by category) -> Rows (Time) When I select specific components in the project filter, if an issue has 2 components, it is counted 2 times. Issues with Original estimated hours resolved: Count of resolved issues with original estimated hours. The problem when I use the measure “Open issues” is if one of the issues close today, this issue dissapear and decrease the number of issues on the previous days. What I want is to create a measure which permit me to have the historical issues that were opened along the year. Therefore measure “Open issues” may not give you expected results when “Status” dimension is filtered. trangvo January 29, 2019, 4:05pm 3. [Issues history], [Transition Status. Measure Issue history counts how many issues are in each status at the end of each time period. The measure its using is issue history. [Done] ) Martins / eazyBI Aug 22, 2023 · Hi, I have a issue-list change history report for single-select custom field which is working nicely. For subtasks, the time period is calculated based on their parent issue data. Nov 22, 2021 · Next, add the measure “Remaining estimated hours history” to the report to reflect your first requirement. 0 ABC-4 ABC 2/11 Mar 2, 2021 · Hi everybody! I’m trying to get the average time of issues, which was in current status at current date in the past. They are grouped by issue resolution date in the Time dimension. [Issues history]) Then you can filter the report on rows to Dec 15, 2022 · Hi @Daniel_Luevano,. Category]. I now want to add a page filter which allow me to only see issues which have been created prior to a specific date i…e. Try this formula instead of “open issues” [Measures]. Here is one more variation you can try. (Afterwards I would like to calculate to average closing time of those issues Mar 16, 2021 · You could change your calculation and use “Issues history” measure in the formula instead of “Transitions to status issues count”. Dec 4, 2019 · Hi @liu. Dec 29, 2021 · Hello, At JIRA we have created a issue linking called block I imported a link to EazyBI called: block Asks for your help to calculate The first link of the block issue linking - the issue to which it was linked The report will look like this: rows - issue column - The first issue linked with a block issue linking Regards shoshi Feb 22, 2019 · Then you can create a tuple with the Priority calculated member and the measure “Issues history”. Currently, only able to get the current due date set, not the Jan 5, 2024 · I want to create a report to show the state of epics historically where: “In Dev” is any In Progress epic that has 1 or more children stories in the Open or In Progress state “In QA” is any In Progress epic that has 0 children stories in the Open or In Progress state and 1 or more in the Ready for QA state “Ready to Ship” is any In Progress epic that has 0 children stories in the Aug 6, 2024 · Hello, I have issues with custom attributes: initial delivery date scheduled delivery date (filled when in progress or closed) I would like a report which show Rows: time Columns, for each month: - the number of issues (closed during the month) with a delay (“scheduled delivery date” - “initial delivery date”) less than 10days, between 10 and 20days and more than 20days. After flipping hundreds of doc pages I stopped at Issue history measure…but it only do counting Oct 23, 2023 · Hi Team, I have a custom field Overall status Delivery which tells about the overall status of Epic. I discovered that among my data, I have several issues that do not have a resolved/resolution date. [Issues history], [Transition Status]. Janis, eazyBI support. My objective is to customize the legend name of the field to remplace “Issues history Submitted”, “Issues history Analysed” by “Submitted”, “Analysed”,… So I think that a calculated measure could be used. Using the Time in the Page to modify the period of study. The function is often used for finding cumulative values over time, for example, the default measure Cumulative story points resolved, or when all activities of previous periods should be considered to get the value for a current period, for example May 29, 2023 · Pages: Project, Issue Type, Status; Rows: Time, Weekly; Measures: [Measures]. I need to create a daily report showing: how many all unresolved tickets were at the end of the day (issue history) - I have it done with the formula (name “All open”): ([Measures]. Add Transition Status dimension to Columns and select"Transition status" level. That will create Feb 22, 2018 · Next, you could double-check if issue change history is selected and imported And finally, you must select to import value changes for your custom field (via eazyBI import settings ). Having those status history as dimension and so forth is a prerequisite, then use Transition Status dimension together with measure Issue history . [Issues history] and [Transition Status]. Nov 20, 2024 · Welcome to the eazyBI community! The “Issue history” measure negative values or higher than 1 indicate the corrupted Jira dataset. Nov 24, 2023 · Hello, I would like to create a calculated measure using Issuees History and status. 0 ABC-2 ABC 2/11/2020 2020. I know why it’s doing it but have failed to be able to prevent it. This is obviously skewing the counts when I use the “Open Issues” measure. 10. but I want to have either conditional formatting to highlight rows which has been changed Feb 10, 2023 · The requirements are: Needs to be independent of sprints (issues are not necessarily in a sprint or are spread over many sprints) Start and End date can be set manually in eazyBi (by creating a measure for example) I am struggling to add the baseline with my current setting (using as columns [Measures]. 1. Unfortunately, eazyBI doesn’t track the “Original estimate” history. . eazyBI allows import and analyze issue change history including: issue status workflow transitions – how many times issues are transitioned to particular workflow status (e. Mar 20, 2018 · Hi @Lars ,. It uses the “Time within version” measure to filter the Time dimension by the currently selected version start and end dates. It seems easy but not sure how to execute. eazyBI imports changes for few dimensions, like “Priority”, “Issue type” and “Resolution” For those, you could see a historical number of issues when using “Time” dimension in report, for other dimensions without history imported eazyBI would return the current value of the field regardless of “Time”. Similar topic in Community: Fix version history on issue. uzan, You may import issue links by specific link type, in your case “block”, but eazyBI does not receive data on when the link was added, unfortunately. The field is currently being imported Jan 5, 2022 · Measure “Issues history” would calculate the number of issues in displayed status at the end of each particular time period. Jul 2, 2020 · To follow up, I did reach out to EazyBI support and got an answer from them, that solved the problem. See the documentation on how to enable and use Issues history and other measures that can be used to get the historical issue status. For example, if you have Months in Rows, you will see the number of issues in each status that these issues had at the end of that specific month. 0 ABC-1 XYZ 3/10/2020 2020. You may consider using the linked issue creation date to see which is the oldest of linked issues. In the Rows section I added Time, and I made a filter to show issues between 2 weeks ago and today. There are two ways how you can check if the issue was Reopened. CurrentHierarchyMember,[Issue]. “B” made “C” assignee who closed the issue. Take “Overdue issues in period” expression as base and make three adjustments. Otherwise, the value will be tied to the respective issue creation date. jingjing, To see which issues have been Reopened, you need to use Issue history change measures . Dec 10, 2018 · Hi @liu. Feb 10, 2023 · Hi! i’m trying to create a report that bring me the name of the status that each issues has been in the selected period. In the report, define a Oct 23, 2020 · Hi, I’ve built a report that gives me the issue status history for each date of a selected sprint. So instead having, for eg. I don’t see this readily available, and I haven’t been able to create a calculated member to do it (the equivalent of the JQL “Story Points” is EMPTY). Thank you so much in advance. Oct 20, 2024 · Hi easyBI community, I am looking to measure the story points for issues added after the sprint starts. Now it’s important for us to see when this field value was changed and preferrable from what, to what. "Monthly" to see how many issues were in each state at end of each month. I tried to add the two following parameters to the custom field but I am getting errors so it looks that it’s not Drag at least one dimension to columns and one dimension to rows to query data. It is important that the story points reflect the current state of the issue (or the Story points when the sprint closed), but not the ones when the story was created. This dimension Mar 20, 2018 · Hi @Lars ,. Need some advice on how to do this. However, the transition status history doesn’t end with the last date of the sprint, it continue to the current day. [Reopened May 29, 2020 · We are creating a report which need to use the Issue History to display the following information as a column: User who moved issue from Status A to Status B Date on which issue moved from Status A to Status B Fix Version Issue Issue Transition Author Issue Transition Date 2020. I want to get/work with all issues, where “B” was involved. All the issues that have been in one of those priorities, but are not in it now, will have a value “zero” with the Issues dimension in rows: ([Priority]. ( [Measures]. Jul 28, 2022 · Hi, I have some problems creating one measure according what I want. You may define a new calculated measure In Measures to count how many issue type changes have been for each issue and in total. Is there a trick or do I have to create a new measure with a case when to To retrieve issue historical values in particular time periods (e. I was To retrieve issue historical values in particular time periods (e. cacus Unfortunately, this formula has a high risk of performance problems, and there is no feasible workaround for that currently. com Feb 6, 2024 · Hi there! I’m struggling with creatng a report that shows how status changed troughout the previous week. Examples. Here is a description with examples of how to do it: Import issue links. [P1 & P2],[Measures]. I’ve searched and tried several things, but cannot seem to get it right. I whant to generate a eazybi report that shows the causes for which a issue changed its original planning. Configure Time dimension as is more comfortable, e. This works fine and as expected. g. The measure “Issues history” does work with both the Time and Sprint dimensions. This is a radio-button field in jira. I suspect the chosen period distorts the report. One desired metric is the count of issues without story points. [Issue]), [Measures]. First, import issue links. As a start, I recommend the Version issues guideline report from our Demo account - Version Issues Guideline - Issues - Jira Demo - eazyBI. It is also desired to view some additional custom field changes, which I can import the change history already according to this instruction: Import issue change history Dec 29, 2021 · Hi @shoshana. Please help me with this issue. CurrentMember, [Issue]. How do I get only issues, where certain assignees have been involved (in history), but are not necessarily assigned anymore. If the overall status is updated as Green this week, it should show none for previous week as the status has not been updated previous week. Use Time dimension in Rows. If I use this configuration: Column Time (Previous week) Measures (issue status) Row Issue I’ve got “In progress” status on those issues wich were in “To do” on a specific date. It is possible to import changes also of other single value custom field dimensions. Aug 19, 2022 · Hello together. In advanced setting specified: [jira. what is average time of issues staying in open status); May 22, 2017 · Note that “Status” dimension returns the current status of an issue even if “Time” dimension would be used in the report. But the due date changes due to some dependency. Thank you Janis for your help. PreviousPeriods returns an optimized set of previous periods that can be used to aggregate measure values for all previous time periods. Kindly, Janis, eazyBI Dec 7, 2021 · Hi, I need some help with this problem. Then your current calculated measure should generate a Pod member name that is the last value at the end of each displayed time period. I have tried this but it uses the current status (now), but not the status at the Oct 29, 2024 · See an example here - Issues burn-down in sprint - Issues - Jira Demo - eazyBI. Issues with Original estimated hours closed: Count of closed issues with original estimated hours. customfield_10330] data_type = “string Dec 3, 2021 · Hello, I have a report which includes the measurement “Issues not closed”. A sample looks similar to this: It is desired to see some default jira field such as assigned, status, priority changes. If you have a specific status for reopened issues, then by using that you can create this calculated measure in Measure dimension that checks issues that have been transitioned to it: ( [Transition Status]. Jun 4, 2024 · The distinct count of the issues history needs a custom formula, as described in this community post: Distinct count for Issue History - #2 by roberts. However I would now like to add a measurement which shows the number of tickets in specific states for the current week. Best, Zane / support@eazyBI. Johannes Current report: Apr 13, 2021 · Hi @Alyssa_A. So you ended up counting just issues created at the period which do not have story points at that period. Is it possible to do this? What should I change in what is presented in the example to achieve this? As the Jan 21, 2019 · The Issue history measure works fine for this case. I currently have a cumulative flow chart to show issues status counts over time. So, we add a custom field called “Motivo de Replanificacion” (reestimation cause) (Type Select List (single choice)). Yes, you can see all previous assignees of an issue. [Sprint issues at closing], [Sprint]. , number of issues with the selected issue type or priority in a particular time period), use those dimensions (Issue type or Priority) in the report together with the measure Issues history and the Time dimension; then you will get the count of issues with the selected issue Mar 20, 2018 · Hi @Lars ,. Changes of issue type are registered in issue change history and also imported into eazyBI. [Transition to status first date], [Time May 28, 2020 · My apologies for all the questions! Today was the first day I was able to invest a big chunk of time on EazyBI. [In Progress]) how many unresolved tickets were at the end of the day more Nov 16, 2018 · Some other customers have requested the same feature to analyze history of Fix versions and we have it in our backlog, but I can not give any estimates as we are still looking for an appropriate solution. That way, you will be able to determine how many issues without Story points you had at any given point in time. [Transitions to status]>0 OR [Measures]. Option 'Import issue change history' should be enabled prior to enabling value change import for any custom field dimension. <Custom field> history counts a total of the custom field value from the sprint issues at the end of the selected time period. [Country] ) This would give the total count of transitions to the specified dimension members. CurrentMember ) > 0 Jun 6, 2023 · How to generate report in EazyBi based on how many time a due date has been changed in an issue type. I have been using both eazyBI AI and ChatGTP to try to get to the formula but does not seem to work. [Issue]), ( [Measures]. For example: I have 25 issues which were in status “To Do” and 2 in status “In progress” on Dec 14 2020. I added a calculated member in the Time Dimension: Aggregate( Filter Aug 28, 2024 · I have been trying to get a calculated measure, that counts the number of issues in certain statuses at the sprint closing. I would like to know the trend of the issues based on the overall status. [Issues history] > 0, DateDiffDays( ( [Measures]. First, i tried using “issue Status” but this measure get the actual status of the issues, so i don’t have the history. I recommend importing the "Story Points" field as a dimension and using the "(none)" member together with the measure "Issues history". The assignee change history is imported in eazyBI, and you can see previous assignees using measures “Issue history” or “Transitions to assignee” together with Assignee dimension. Mar 14, 2022 · Count( Filter( DescendantsSet([Issue]. Regards, Trang Mar 22, 2018 · Hi Lars, You were on the right track with the first formula! The incorrect part there is that you first filtered ‘Issues created’ which on Timeline gives only issues created in that period. 0 ABC-3 XYZ 3/10/2020 2020. This is the latest from eazyBI AI: Sum( Filter( Descendants([Issue]. [Transitions to issues count], [Transition Field]. 0. I’ve confirmed that all the issues that are missing the resolution date have a status of “Release Sep 6, 2024 · Hello! I’m trying to create a board in Eazy Está BI that gives me a view of burndown and burnup like the one presented here: Sprint burn-down or burn-up chart But I need the issue’s done criteria to be a certain status on my board, not the status of done, as is the default. That would change the logic for your calculated measure and it would look at issues that were in the Transition status at the end of each time period (regardless when they reached the status) Dec 2, 2022 · Hello, I’m stuck with one report and I can’t find help on other similar topics here. 10 issues in Done, I have 11 (9 issues with one component and one issue with 2 components). Hidden measure. Then i tried using Mar 23, 2022 · Hey, What if in the Issue, person resolved it but he is not counted in the “issue resolved” measure? He is not assigned to the task anymore because this Issue is resolved 🙂 In the history of the Issue I can see that he resolved it, thus I have a proof 😉 I used Assignee and as you can see he has 4 created Issues but any resolved. Could give me a hint on how to do this? Thank you. However, I have 3 worries: issues history curves continue after the current date. On the graph, I’d also like to display the day’s line, then draw prediction curves based on figures from previous weeks. [Issues history] Now, I would like to add a new measure based on a weekly timeline to known how many issues are covered using the above custom field. Try the following formula - it first filters that issue is created before the end of the . Say i have an issue type, defect and the defect would be set with a due date and a fix version. Here is an example with a custom field ‘T-shirt size’ I have imported changes to: [Issues_-_eazy… They are grouped by issue resolution date in the Time dimension. Jan 29, 2019 · I am trying to measure/assess/report on the health of the backlog. and I have measure: NonZero( Cache( nonzero( IIF([Measures]. before 18th Nov. It shows list of issues (epics with some page filtering) as rows and columns contains months and the values are the custom field string values (2023-Q1, 2023-Q2, 2023-Q3, etc…) selected for each epic. how many times issues are reopened) or how long issues stay in particular workflow status (e. There could be a way to create a calculation but usually dealing with multi-value fields when you need to exclude something is a complex query behind the report and it can make the report slow. First, here’s a picture of the report (I have sprints in Pages so I can filter by one sprint at a time Oct 6, 2021 · The Issues history measure, when used together with the Transition Status and Time dimensions, will return the historic Status that the issue had at the end of your chosen period. [Issues history]>0 ) ) It should count issues that either reached on of transition statuses during the sprint timeline or that were present in those statuses a the end of the sprint’s time period. midff hmfhd tsquv jbakc zszoq wwbl bwmcerzt ctvxf wzkoix lqtv