Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

How to include empty values into Insight/Assets Reports?

Przemysław Grzesiak September 14, 2023

Hi

 

I need to create a report showing percentage of assets statuses. It is rather straightforward and simple report however in the result only assets with a value in the attribute and the ones with no value are not counted. Is there any way to count all the objects of specific object type and see in the report that for example 30% does not have value at all?

3 answers

2 votes
Danut M _StonikByte_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 14, 2023

Hi @Przemysław Grzesiak,

You can easily do this with our Great Gadgets plugin. 

By using its Advanced Issue Filter Formula Gadget you can calculate counts and percentages based of the issues from up-to 6 filters. 

image.png

Please note that this plugin offers many other gadgets for creating powerful dashboard for tracking ISTM metrics in Jira. It will be of huge help for you and your teams!

 Have a look over this article from our blog to make an idea: An effective dashboard for Service Desk and Customer Support teams in Jira Service Management  

I hope this helps. If you have any questions, please don't hesitate to contact us at support@stonikbyte.com. 

Thank you,

Danut Manda

2 votes
Wouter van den Berg
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 14, 2023

Hi @Przemysław Grzesiak

Haven't been playing with Jira Service Management Server for a while but maybe you can make this work. I'll give you the simplified version for you to play with and come up with your own version. There are way cleaner solutions that could solve this within one single line but I tend to stay away from solutions like that as only a handful can actually maintain it and have all edge cases resolved. 

Again, I have Cloud and I am not sure if your Server automation allows for the same. Star with your scheduled trigger. Do a lookup objects and select your schema and have your status attribute targeted in the query with is not empty. 


Screenshot 2023-09-14 at 17.24.00.png


This will return all objects that have a Status. 

Now we will store that into a variable. Again, there are a lot of "helpers" out here that could solve that in one line but you will learn nothing and have something you won't understand in one years time. So let's stick to easy and understandable. 

We store the lookup objects variable like this: 

Screenshot 2023-09-14 at 17.30.52.png

VARIABLENAME
{{lookupObjects.size}} 

This will store the number of Objects it has found that have a Status. We can later use that number to do the math. 

We now do a Lookup again and just want all of the objects to be able to calculate a percentage. In my example I am just retrieving all of the objects: 

Screenshot 2023-09-14 at 17.32.37.png

I store this in another variable. 

Screenshot 2023-09-14 at 17.33.54.png

Now I have the total number of Objects and the number of Objects that have a status. Now I will be able to do the math: 

Screenshot 2023-09-14 at 17.35.00.png

I just realised I forgot to update the naming of the variable. Emptystatus should be Objectwithstatus for example. But I didn't feel like going over the screenshots again as I explained what I am doing. So with this I am logging a percentage. 

In my example:

- EMPTYSTATUS (or better yet OBJECTS with Status) = 3 
- ALLOBJECTS = 27

So 3 * 100 / 27 = 11.11111% 

Of course you can round that or even have smarter logic within one or two actions to get to your result. I didn't talk about edge cases that could break your calculation. I am merely trying to get you up to speed in possibilities and let you figure things out by playing around. 

You can find more information here: https://support.atlassian.com/cloud-automation/docs/jira-smart-values-math-expressions/

or here: https://support.atlassian.com/cloud-automation/docs/jira-smart-values-conditional-logic/ if you want to go nuts. Hope this helps and you can start playing around with the logic.

In my example I am logging the result but you can also send this via email or whatever. Let me know if this works on Server. 

0 votes
Przemysław Grzesiak October 4, 2023

Hi @Danut M _StonikByte_ 

Thanks for your input but unfortunately such options are not available in automation for insight on Data Center edition.

Danut M _StonikByte_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 4, 2023

Hi @Przemysław Grzesiak,

Yes. Great Gadgets is a plugin for Jira/Confluence Cloud that you could install and then use its gadgets to create dashboards in Jira or pages in Confluence to serve as reports.

Danut.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events