nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Creating a dash board

Roger Davidson_yqnfha

I am creating a dashboard with all open statuses. With the following formula, what items should I have in my formula for Statuses that have not been closed?

project = DOG AND resolved >= 2021-01-01 AND resolved <= "2021-12-31 23:59" AND Status = Closed AND "Epic Link" = DOG-6999

I know that Status = CLOSED should probably be OPEN, however, What should RESOLVED be?

Accepted answers

Bill Sheboy

Hi @Roger Davidson

Would you please describe what it is you want to see (the problem you are solving)? That may better help the community to give you suggestions. Thanks!

Best regards,

Bill

All comments

Roger Davidson_yqnfha

This is the formula that I am using project = DOG AND NOT resolved >= 2021-01-01 AND NOT resolved <= "2021-12-31 23:59" AND Status = EMPTY AND "Epic Link" = DOG-6999

The above formula is replacing this formula but it is not picking anything up: project = DOG AND resolved >= 2021-01-01 AND resolved <= "2021-12-31 23:59" AND Status = Closed AND "Epic Link" = DOG-6999

Any suggestions would be greatly appreciated

Bill Sheboy

Hi @Roger Davidson

Would you please describe what it is you want to see (the problem you are solving)? That may better help the community to give you suggestions. Thanks!

Best regards,

Bill

Roger Davidson_yqnfha

@Bill Sheboy

I have 7 epics that I want in a dashboard for all 7 in one graph. In the training course, I took yesterday, I was able to see a graph that combined all items in one graph. So what I envision is a graph that combines all of my epics in one graph showing from the start when the issues were created progressing until closed. I think it can be a bar-graph.

These are the formulas that I finally got to work, I have 7 formulas that I would like to combine as one formula but I don't know how to do this: here are the formulas I am using:

project = DOG AND created >= 2021-01-01 AND created <= "2021-12-31 23:59" AND Status != Closed AND "Epic Link" = DOG-6999

project = DOG AND created >= 2021-01-01 AND created <= "2021-12-31 23:59" AND status != Closed AND "Epic Link" = DOG-6998

project = DOG AND created >= 2021-01-01 AND created <= "2021-12-31 23:59" AND Status != closed AND "Epic Link" = DOG-11662

There are 7 of these formulas but if someone could give me an idea of how to combine them as one formula that would be wonderful.

Roger Davidson_yqnfha

dashboard creation.PNG

Hi @Bill Sheboy

The above graph is exactly what I am looking for. I found this in the JIRA training I am doing but I don't know how to combine the formulas from the last post I made. Would someone have an idea of how to create this graph?

I am using a KANBAN board and the above example is using sprint as an example

Thanks,

Roger Davidson

Bill Sheboy

Hi @Roger Davidson

That built-in bar chart is for a Sprint (as you note) and so cannot combine information for other data. The two closest matches (built-in gadgets) to get what you ask is the Pie Chart or the Issue Statistic gadgets. For more gadget options please check the marketplace for purchase options.

Regarding combining your queries, you are very close to having it right...When combining queries, look at what is common and different to decide a solution. For your case the Epics are what is different, so please try this:

project = DOG
 AND created >= 2021-01-01
 AND created <= "2021-12-31 23:59"
 AND Status != Closed
 AND "Epic Link" IN (DOG-6999, DOG-6998, DOG-11662)

Best regards,

Bill

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-server