How to include empty values into Insight/Assets Reports?

[Przemysław Grzesiak]

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?

[Danut M _StonikByte_]

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. 

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

[Juraj Ricany]

Wow. This is really a solution .... sorry, ServiceNow is simply always better. Why such default functionality is not available here is a mystery. Worst tool ever. 

No doubt this works, but its just painful. 

[Wouter van den Berg]

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. 

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: 



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: 



I store this in another variable. 

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: 

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. 

[Juraj Ricany]

I'm struggling with the same and you know what is the best solution? Excel!!! Or PowerBI or essential anything just not JIRA or any of the Atlassian products. Ever. Lobbying for ServiceNow. Never have I used worse tool then this. 

[Przemysław Grzesiak]

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

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.