Too many elements to display breakdown error in PA

[Abhijit4]

Hi All,

We have created indicator on Metric Instance to find out assets total In Stock/In Use duration. We have used breakdown on alm_hardware table with some filters, While preview it shows around 22k records. In system property breakdown maximum record count is set as 100000 which is greater that preview record count. Still we are seeing "Too many elements to display" message.

Breakdown definition:  we know that hardware sys_id will return too many records but we have used conditions to reduce it to around 20k record, we are basically adding hardware asset breakdown on metric instance table to find total In Stock/In Use duration for individual assets.

Does anyone has any input to resolve this issue?

@Adam Stout 

[Bert_c1]

Post your Breakdown definition and you may get some useful response.  Fields that have too many different values will cause what you see.

[Abhijit4]

Added breakdown definition details in question.

[Adam Stout]

You may need to add some breakdown exclusions.  On the indicator, click on manage breakdowns to see if there are some with a large number of element combinations in the matrix that are not needed and can be excluded.  Check out the documentation on how to do that at: https://docs.servicenow.com/csh?version=latest&topicname=configure-breakdown-matrix 

[Abhijit4]

Thanks Adam for your reply.

I believe breakdown exclusion is applicable when we have multiple beakdowns but in our case we are having only one breakdown.