Platform analytics trend cases report by state

[valesky]

Hello,

I have a Platform Analytics dashboard, and I’ve been asked to create a report showing the monthly trend of cases by status. Specifically, I need to display:

• The number of cases that were in "New" status each month (e.g., how many were in "New" status in August, in September, in October, etc.).

• The number of cases that were in "Open" status each month.

• The number of cases in "Awaiting Info" status each month.

• The number of cases in "Resolved" status each month.

To achieve this, I followed these steps:

1. I created an Indicator Source called "Case Indicator Source" using the Case table as fact table, with no conditions applied.

2. Then, I created four Automated Indicators, one for each status:

   • New Cases Indicator

   • Open Cases Indicator

   • Awaiting Info Cases Indicator

   • Resolved Cases Indicator

   Each indicator uses the "Case Indicator Source" and has an additional condition filtering by status. The aggregation is set to Count.

3. I added these four indicators into a Data Visualization widget on the dashboard.

However, the indicators are not working as expected. For example, the Open Cases Indicator shows counts for September that include cases created in October—cases that didn’t exist in September.

Where an I foing wrong?

Thanks for your help

[MaxMixali]

2. Why you don’t see it now

If you’re on Utah, Vancouver, or Washington, ServiceNow removed the checkbox from the UI form.

However, the field still exists in the dictionary of pa_cubes (hidden).

You can verify it easily:

✅ Steps to confirm

1. Navigate to:

   System Definition → Tables & Columns

2. Search for pa_cubes

3. Open the record and go to Columns

4. Look for the column:collect_records_even_if_unchanged

1. Type: true/false (boolean)

You’ll see that it still exists, but is not on the default layout.

---

🧩 3. How to re-enable it (if you really need it)

If you want the same functionality as before:

1. Go to the Indicator Source form layout (table: pa_cubes).

2. Configure → Form Layout

3. Move the field Collect records even if unchanged from the “Available” to the “Selected” list.

4. Save → The checkbox will appear again.

✅ Once visible, when checked, ServiceNow will collect all matching records even if unchanged.

---

⚠️ 4. Caution — behavior impact

Enabling this option can increase collection time and storage usage, because:

• Every collection will insert all matching rows again.

• If the fact table is large (e.g., task), you’ll double-count records unless indicator aggregation is unique.

[valesky]

Unfotunately I don't have this filed in the table

The instance was  just upgraded to Zurich versione