Performance Analytics Breakdown of empty fields

[asilva3]

Hello, I'm working on a dashboard to help my process owners detect where procedural activities in record population are being missed either because of other automation or user error.

As my example use case lets say I have tasks in a work in progress state.   However, "Assigned to" is empty OR "Short Description" is empty.

I created an indicator for all records where either Assigned to OR Short Description is empty.   Now I'm stuck on how to create the widget and breakdown so that I can drill down on which records from the indicator are missing Assigned to as one breakdown choice or if Short Description is empty as the other,

My initial path of creating a breakdown for "Short Description" with a filter of is empty, actually gives me the ability to choose specific records in the breakdown selector instead of the category of "Short Description"   I suspect I'm missing something logically simple but I'm stuck and appreciate any help.

[asilva3]

I think I've determined the path forward here is the use of a Bucket Group.   I'm looking at some of the OOB uses of this to figure out how to script the indicator appropriately.   If anyone has a simplified guide that would be a big help.

[Arnoud Kooi]

Didnt see your own response you wanted to go for a bucket group.

To get you started, this is something I would do

Create the bucketgroup

Create script

Create Breakdown source and Breakdown

Below 2 screenshots.

The script is not tested, but should serve as a good start!

Bucket group

Script

function getErrorCode(sd,at){
   var rtrn = 0;
   if (sd == '') rtrn += 1; //not tested,might be a null value
   if (at == '') rtrn += 2;
   return rtrn;
}
getErrorCode(diffcurrent.short_description, current.assigned_to);

[Arnoud Kooi]

I would choose between 2 approaches:

• Create 2 automated indicators for each issue. You can sum them with a Formula Indicator and display the 3 indicators in a time series widget.
• Keep the current indicator and add a bucket group breakdown, lets say 1 is Empty Short Description and 2 is Unassigned. In the breakdown script return the appropriate value.

Hope this gets you started!