Record Count in Visualizer and show the result in KPI

Jayson Joaquin · 2025-04-05T00:03:14+00:00

There was an error rendering this rich post.

Hi Team,

We have a report that shows the number of records. We want to get the total records in the report and show the total report in KPI Dashboard. May we know how can we do this?

Find more posts tagged with

Accepted answers

All comments

Jayson Joaquin

This is the value we want to show in the KPI and it is dynamic depending on the filter applied

Diane McElhiney

First, the BudgetId needs to be defined as type measure or both in the Scripted Source/Source Properties which creates the measure table. Then you define the KPI using that BudgetId measure and choose Count (by a date defined as Analyze by Date). Filtering is accomplished by creating filters on the dashboard and associating them to the KPI object (the filter icon appears in the lower right corner of the dashlet). This approach is the simplest solely based on your screenshot as you have not stated whether the model id currently in production or development or if it is an Analytic Solution.