Discussions
-
Structure question when using the Gantt settings
I'm having trouble understanding how to use the Gantt settings on my structure. I want to be able to visualize a "projected finish date" based on today's date + the remaining estimated time. The formula I'm using is DATE_ADD( today(), CEILING(JIRA_DAYS(remainingEstimate)), "day")which is working in terms of rounded up, raw…
-
Structure - using Gantt chart to visualize project end date
I'm having trouble understanding how to use the Gantt settings on my structure. I want to be able to visualize a "projected finish date" based on today's date + the remaining estimated time. The formula I'm using is DATE_ADD( today(), CEILING(JIRA_DAYS(remainingEstimate)), "day")which is working in terms of rounded up, raw…
-
Can't seem to access changelog smart values to create a slack message.
I have a JIRA automation setup to trigger whenever an update occurs on JIRA issues that have a specific label. The triggered rule sends a formatted message to a slack channel to bring awareness to the change via web hook. Here is my message that attempts to use smart values: *{{issue.key}}* – {{issue.summary}} was updated…
-
Gantt Charts for Structure - Sandbox mode
I am reading up on baselines and how to effectively use them in my structures and I stumbled across this in the documentation: Creating a Sandbox | Tempo Help Center However, to create one the documentation showed this image This shovel icon does not appear for me. Is this something that needs to be enabled on the admin…
-
Trying Dashboard Hud - Seems to lack basic JIRA gadgets?
I want to create a simple Created vs Resolved chart with cumulative values over a time period like the gadget native to JIRA. I see the JIRA Charts gadget and still cannot reproduce the chart below. I've only been able to do this Am I missing something?
-
Structure formula column: How do I reference a specific issue by key?
Hello! I want to access the attributes of a specific issue referenced by its key. For example, I want the ganttduration of key "ABC-1234." Is this possible? If so how? Thank you in advance! Yvette
-
Creating a Structure formula column: Want to calculate days remaining based on JIRA work days.
Hello! I have a structure formula column where I want to show the days remaining between NOW() and the due date on an issue. Trick is I want it calculated based on our JIRA configurations and to include US holidays. Essentially I want remaining business days until the Due date. The calendar set in my structure's general…
-
Creating a Structure formula column that lists issues of a custom issue type
Hello! I have a structure formula column where I want to show an array of open issues of a certain type. We have a custom issue type called Risk. When I use the following formula I get all the linked issues of type Risk issueLinks.FILTER($.type = "Risks")Great so far.Now I want only the ones that are in some state of…
-
Creating a Jira structure formula to find the array of open issue types
Hello! I have a structure formula column where I want to show an array of open issues of a certain type. We have a custom issue type called Risk. When I use the following formula I get all the linked issues of type Risk issueLinks.FILTER($.type = "Risks")Great so far.Now I want only the ones that are in some state of…
-
I would like a Structure formula column that indicates the date a specific field was last updated
Hello, Hopefully there are some Tempo Structure gurus here that can help me. I have a custom field that is simply another labels field to separate it out from the generic Jira labels field. What is the formula to display the date that this custom field was last modified? Thank you in advance.
-
Using a string concatenation to filter labels
I would like to concatenate a string from a dashboard text controller (RM_ID in my example) and search for that string in the labels field. I do not know how to use the CONCAT operation within labels or even if I should be using CONCAT at all to get the desired result. SELECT COUNT(DISTINCT `Issue`.`issue_id`) AS `Count of…
-
Dropdown showing every combo of a custom field as an option to select
I have created a dropdown control based off a custom field. This custom field can have multiple values when being set on our jira issues. This is causing the dropdown options to be every combination used. How do I make the dropdown only show the individual values? Example, I only want the dropdown to show A, B, C and not…