How define a PA Bucket Groups for fields with no value?

[Mark Nguyen]

Hi PA Community,

I have set up PA Buckets to group assets into age buckets based off received date. This is working correctly for all assets that have a Received date as seen in my example below:

The problem I have is for any assets where there is NO Received date the assets are all being grouped into my 120+ Day range. I would like them to be grouped in a NO DATE bucket if possible.

Any advice on how to set up this NO Date bucket?

Thank you

[Community Alums]

Hello,

I think since value is not present it consider it as NA. So when value is empty, it needs to be considered. 
You can do this by entering below setting in Indicator.




This empty value will be considered as 0 and it will fall under NO Date Bucket.


Could you please try and let me know if it helps.


Regards,
Akshay 

[Mark Nguyen]

Hi @Akshay Kangankar,

Thank you for your response and time. In my Automated Indicator I have value when nil currently set to '0'.

What is actually happening is the Breakdown is a script and is grouping the scores into PA buckets. I guess I need that when no value is present I need the breakdown to put the assets with no scores or empty received date in it's own bucket.

[Community Alums]

Hello Mark,

Yes, you need to check if value is empty then put it's value as "0" days in breakdown script only. I guess this will work for you. Since currently value is empty it is being skipped and not considered in the calculation.

Regards,
Akshay 

[Mark Nguyen]

Hi @Akshay Kangankar 

This is my current Breakdown break for the PA buckets

var diff=function(x,y){return y.dateNumericValue() - x.dateNumericValue();};
var days=function(x,y){return diff(x,y)/(24*60*60*1000);};
days(current.receiving_line.received, score_end);

Do I need to modify this script that if the value is empty to put it's value as "0" days as you mentioned?