I'm trying to determine if a PA script will solve my problem.
The metric I'm trying to create seems simple, but I can't figure out how to do it in 1 Automated Indicator.
In my change_request_metric table, within the definition of 'Change State Duration', I have a value of 'Activated'. I need to count the records closed complete that do not have the value 'Activated'.
What I've had to do is the following:
1. Create an Automated Indicator of closed complete records, count distinct on sys_id.
2. Create an Automated Indicator of closed complete records, value is 'Activated', count distinct on sys_id.
3. Create a Formula Indicator that is Automated Indicator #1 - Automated Indicator #2.
The Formula Indicator is the correct count. But since this is a formula indicator, I'm unable to 'Show Records' on the Analytics Hub.
I'm hoping that a PA script can be written to provide me the correct count, and be able to 'Show Records' on the Analytics Hubs.
Thanks in advance for looking at this.
