Creating a dash board

[Roger Davidson]

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?

[Bill Sheboy · Accepted solution]

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]

@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]

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

[Roger Davidson]

Hi @Bill Sheboy 

Thank you so very much for replying to my messages. I really appreciate it. Thank you for the clarification on the formula. I will look at the marketplace for some more gadgets.

Thanks,

Roger

[Bill Sheboy]

Roger, if this helped you please consider marking this question as answered.  That will help others with the same request find solutions faster.

And, if you discover a marketplace add-on which meets your needs, please consider posting back here what you learn so others can benefit.

Thanks!

[Roger Davidson]

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