Indicator monthly score is showing count incorrect in platform analytics

kiran115
Tera Contributor

I have created an indicator to retrieve all of the SLAs for RITMs and to break them down by item owner. For this, I am using the 'sc_req_item_sla' table. I developed a monthly-based indicator and set the source accordingly. I am able to display the count in the Platform Analytics dashboard using pivot visualization, with the columns representing the item owner. The counts are displaying correctly on the dashboard.

However, when I click on the count for each owner, it shows the correct number but only displays 10 records in the detail view. I have checked all possible options, and in the 'pa_snapshots,' the sys_id count is accurate as well. I have attached a screenshot for reference.

kiran115_0-1763990550517.png

And for some owners it show correct as below.

kiran115_1-1763990635104.png

 




 

1 REPLY 1

Matthew_13
Kilo Sage

Hey there!

  The indicator is calculating the count correctly, but the drill-down view only shows the records that were stored during data collection. By default, PA stores a limited number of record sys_ids per snapshot (often 10), which is why the detail view stops there even though the total count is higher.

This is also why it works for some owners and not others — owners with fewer RITMs fall under the snapshot limit, so all their records display, while owners with higher volumes hit the cap.

I would say to fix it, check the Platform Analytics property com.snc.pa.dc.max_records, increase it to a reasonable value, and then re-run data collection. Existing snapshots won’t update automatically, so re-collection is required.

Basically the key takeaway is that this isn’t an issue with your indicator or breakdown logic it’s a snapshot storage limit designed to protect performance.

 

@kiran115 - Please mark as Accepted Solution and Thumbs Up if you find Helpful!!