Nicholas Ellis _ALM Works_ Atlassian Partner

Hi Jochen, This formula does not need to be incorporated into the old one. It should work alone simply copy and paste it as is. Cheers, Nick [ALM Works]

Hi Jochen, Here is an improved version of the formula to handle multiple max values better. WITH maks = array#subtree{FE}.MAX(): WITH all = array#subtree { array(FE, item) }: WITH res = all.FILTER($.GET(0) = maks).flatten().FILTER($.GET(0) != maks): WITH count_si = COUNT#truthy{FE}: IF count_si: CONCAT(maks; " / "; res)…

Hi David, Welcome to the community! First I should mention it looks like this answer is tagged with Jira-cloud, but you are definitely on Server or datacenter. On cloud you can't have one formula reference another. Secondly, I've reformatted the code so it is easier to read but haven't changed it functionally.…

Hi Jochen, This one is deceptively complex, but the good news is you don't have to construct the URL yourself. All you have to do is set the output to wiki markup and it will automatically make the keys into links. Here is the code: with max_num = MAX{numericRAG} : with keys = VALUES#strict{key} : with index =…

Hi Nadya, If you add a date or date time field to Jira. Then simply adding the column will make this field editable, and bring up a date picker when you click on it. Here is a screenshot to illustrate. Step 1 is adding the date column with the plus (assuming it already exists in Jira, and you have permission to edit), and…

Hi Floris, Welcome to the community! This is actually pretty easy to solve with Expr. We can access issue links, and then pull in values from the linked issues. I'll assume the link is a blocks type, but you can look for any type. issueLinks.FILTER($.destination = this and $.type = "blocks").map($.source.value_points)…

Thanks @Dave LIAO, It works slightly differently on different deployments. On cloud we have a lot of built in emojis, here's the list if you're interested. On Server/DC we use the Jira built in wiki, which has slightly fewer emoji options. The other option would be to insert a "■" character and make it the same color as…

Hi Marcel, This is pretty straight forward in Expr 2. You just check the list of labels against an array of items you are looking for like so: labels.FILTER( ARRAY("Windows 2012", "Windows 2016") .contains($) ) Then you can group by this formula using the attribute grouper. Attribute grouper documentation. Cheers, Nick

Hi Cristian, Welcome to the community! To do this in a formula column we would likely have calculate our burndown rate based on the past 6 months. Which could simply be a structure of all completed issues in that time that rolls up the estimates. This should get us to a number like 108 story points over 6 months. This…

@Rnts6NL7bo On cloud (or Server/DC) you can now do a very simple formula like so: sprint.startDate sprint.endDate Here is the relevant documentation if you'd like to learn more: structure cloud formula documentation Cheers, Nick [ALM Works]

This answer is a bit old, this is much easier to do now. On cloud (or Server/DC) you can now do a very simple formula like so: sprint.startDate sprint.endDate Here is the relevant documentation if you'd like to learn more: structure cloud formula documentation Cheers, Nick [ALM Works]

Hi Janene, Unfortunately this is not possible today. The start and end dates are attributes calculated from the Gantt chart. However if you look at our roadmap, you can see that Gantt attributes in Structure is at the top of the list. I would expect this is something that you will be able to do by the close of Q2. Cheers,…

Hello Frederic, Welcome to the community! The short answer is if you want to simply have Structure.Gantt give the team a week off you can do that in the resource settings, just set availability to 0% for that week. Here is the related documentation As for the error you're getting, it is because the leveling priority field…

Hi Billy, You can use your "was in progress during..." JQL query if you like, but I expect the performance will be much worse, as WAS queries can be quite computationally expensive. As long as the structure is not very large (1k+ issues), I wouldn't expect it to be too much of a problem, but it is worth mentioning. Cheers,…

Hi Billy, You could use the sprint dates, but there are some interesting complications you can run into, such as an issue being in multiple sprints. I would use the resolved date, and then define a date range around it. for a trailing date I might do something like this: IF DAYS_BETWEEN(resolved, NOW()) < 30: 1 or if you…

Hi Amedeo, This looks correct to me. The one thing that might cause this to not work is if the extender is not set to the correct levels. The default is all levels up to 10, but if it was set to levels 1-2, it wold not show the relationship as the linked sub task is on level 4. If that does not solve the problem, please…

Hi Amedeo, First I should mention I work for ALM works, the makers of Structure. I can't speak to how Tasktop works, but your assertion is correct that you could set this up with automation in Structure. It would be an extend generator very similar to the parent child hierarchy you mention. The main difference is you would…

min{duedate} should work by itself, the #subtree isn't needed. If it is still giving you the AGGR? error, I would reach out to our support team support@almworks.com

Hi Guy, I realize you didn't mention Structure for Jira, but naturally it is good for structuring a hierarchy like this. The pun is unavoidable. Let me restate the problem to make sure I understand what you are saying. We have epics and under those epics we have some issues. We want to create a grouping in between the…

Hi Jochen, All wiki markup is a string to be parsed. You simply need to quote the value, so this:  becomes "" Apologies for not mentioning that. Also it looks like you are still using my example link. That does not…

Hi Jochen, EDIT: Unfortunately this does not work anymore. This relies on the underlying Jira markup, which was updated, and no longer supports images. This answer has more info https://community.atlassian.com/t5/Jira-questions/How-to-embed-images-by-URL-in-new-Markdown-Jira-editor/qaq-p/1126329 Original answer for old…

Hi Daniil, I have included instructions below. Please let me know if you have any questions or run into any issues. 1. Include all relevant issues in the board. My insert JQL was "type in (story, bug)", yours might be more complex. 2. Create a formula like this: if(type = "Story"; assignee; type = "Bug"; reporter) 3. group…

Hi Pero, I see that you already figured out the answer for yourself. I just wanted to explain why it works that way. When we have a variable like key, Structure will try to define it. It will try to guess what it is based on its name. Key matches the exact name of a jira field so it picks it up automatically. But if I…

Hi Ricardo, First and foremost I am from ALMWorks, so my suggestion does involve using our tools, specifically Structure. Today in Structure you could create this report in Jira to have up to date information on what these story point values are, even if they have changed. We even allow you to group by Sprint and them sum…

you could do something like this to remove dates before a particular time. with min_date = MIN{start_date}: if(start_date > min_date; concat("date before " start_date); min_date) Here if we assume we are on the epic level we see if the min_date of children is before the current rows start date. If it is we print "date…

Hi J, I would file a ticket with our support team. you can email them at support@almworks.com, or file a ticket at https://support.almworks.com Cheers, Nick

Hi J, The min{} function should ignore nulls all on its own. So you should be able to just do this as your formula: min{start_date} On the Epic level this will find the minimum start date (including the epic's start date). If you want to only consider the child dates below the epic level you could do…

Hi Etienne, Your assessment is correct this is they way that it works currently. Unfortunately there is not a good way to handle this with formula groups. The problem is a labels field returns multiple values so the issues go into multiple groups, but a formula can only return a single value. The good news is there are…

Hi Itay, Unfortunately there is no way to do this with the Plan app. However Structure does have a Gantt extension for creating plans like this using the structure hierarchy. https://marketplace.atlassian.com/apps/1217809/structure-gantt-planning-at-scale?hosting=server&tab=overview (Thank you for using Structure). Nick…

Hi Sai, Unfortunately this error does not give a lot of information. It just tells us that the Gantt chart was unable to be built. This is likely because something made it impossible to build. It could be bad values in your manual scheduling fields, inability to access those fields, or something else entirely. I'd suggest…