Help with creating PA percentage indicators

pavan Punna
Tera Contributor

3 weeks ago

I need to create two PA percentage indicators based on three counts: unique licensable Discovery products, products with a matching Software Model, and products with an assigned owner.

A background-script POC successfully groups Discovery Models by Publisher, Product, and Edition and matches them to Software Models. Since this cannot be represented using ordinary encoded queries, what is the recommended approach for collecting these aggregate scores in PA without creating a custom reporting table? Can a PA script call a Script Include once per score collection, and how can I verify it does not execute once per source record?

0 Helpfuls
  • 229 Views
1 REPLY 1

Vikram Reddy
Tera Guru

3 weeks ago

Hi @pavan Punna,

 

Skip the custom reporting table: build each count as a Scripted Indicator Source, not a scripted aggregate on a plain Automated Indicator (that flavor can't use GlideRecord or GlideAggregate at all), then combine the two counts in a Formula Indicator as (matched / total) * 100. Indicator sources get queried once per collection run no matter how many indicators reference them, so a Script Include called from that script fires once per collection, not once per Discovery Model row. Confirm that instead of assuming it:

  • Indicator Source type is set to Script, not Table, so the Script Include and GlideAggregate grouping logic actually run.
  • Script Include increments a counter or logs via gs.info() so you can count invocations after one manual run.
  • System Logs show one entry per collection execution, not one per product record.
  • Formula Indicator references the two scripted indicators directly, not the raw Discovery/Software Model tables.

References

 

Thank you,
Vikram Karety
Octigo Solutions INC

0 Helpfuls