PA Script
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-16-2024 12:14 AM
I need help building a PA script for the following use case -
I would like to use a predefined multiplier that varies based on the outage type. If the outage type is "Outage," the multiplier will be -10; for "Major Degradation," it will be -7; for "Degraded," it will be -4; and for "No Service Impact," it will be -2. For example, if there are 2 outage records of the type "Outage," the calculation will be (2 * -10) = -20.
I have attached the PA Script form, which displays the facts table and the necessary fields that need to be utilized.
Can someone please help me in this regard?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-16-2024 02:18 AM
I am not sure I understand what you are trying to achieve. Your script is going to run for each records in your facts table. How do you expect it to know how many records of a specific type there are in that table?
Blog: https://sys.properties | Telegram: https://t.me/sys_properties | LinkedIn: https://www.linkedin.com/in/slava-savitsky/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-16-2024 03:26 AM
There is no script that I have written for it yet but it is written properly then it will be able to fetch the records from the facts tables and the relative fields.
I want to measure the impact of the Outage based on its Type.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-16-2024 03:28 AM
Once I write the script properly, it should be able to fetch records from the facts tables and related fields. I aim to measure the impact of each Outage based on its Type.