PA Monthly Count from Jan 2025 and Month-over-Month Variation Showing Same Score

[Deebika]

Hi Team,

I am working on a Performance Analytics automated indicator on the cmdb_ci table.

Requirement:

- Show monthly count of Installed CIs from January 2025 onward.

- Continue collecting scores for future months.

- Display month-over-month variation (e.g., Feb 2025 - Jan 2025, Mar 2025 - Feb 2025).

- Show both monthly counts and variations in a bar chart.

Current configuration:

- Indicator Type: Automated

- Aggregate: Count

- Frequency: Monthly

- Table: cmdb_ci

- Condition: Install Status = Installed

- Historical Data Collection:

   Relative Start = 20 Months Ago

   Relative End = 0 Months Ago

Issue:

The historical collection runs successfully, but the same score is generated for every month instead of month-specific counts.

Questions:

1. For collecting monthly scores from January 2025 onwards and continuing for future months, are the following settings correct?

   - Relative Start = 20 Months Ago

   - Relative End = 0 Months Ago

2. Should the indicator source include a Created (sys_created_on) condition or any time-based condition?

3. What is the recommended approach to get different monthly counts instead of the same score for every historical month?

4. For month-over-month variation, should I create a Formula Indicator using:

   Current Month Score - Previous Month Score

   or is there a better PA approach?

which method I need to use

Any guidance or example configuration would be appreciated.

Thank you.