KPI reporting - chart type
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
an hour ago
Hi,
I want to create a dashboard in Platform Analytics showing how many incidents were opened, resolved and inprogress for a particular assignment group on a weekly basis. Is there a way to create a chart like this?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3m ago
Hi @rdevi ,
Yes. You can build this in Platform Analytics using three indicators (Opened, Resolved, In Progress) collected weekly, with an Assignment Group breakdown, shown on a column chart. Step by step:
Step 1: Create the indicator sources (weekly)
Go to Platform Analytics Administration > Indicator Sources and create three, all on the Incident table with Frequency = Weekly:
- Incidents opened weekly. Condition: Created on This week
- Incidents resolved weekly. Condition: Resolved on This week
- Incidents in progress weekly. Condition: State is In Progress
Platform Analytics evaluates relative conditions such as "This week" against the collection date, so each score covers the correct week.
Step 2: Create the indicators
Create one automated indicator for each source:
- Number of opened incidents (Aggregate: Count)
- Number of resolved incidents (Aggregate: Count)
- Number of in-progress incidents (Aggregate: Count)
Set Frequency = Weekly on each.
Step 3: Add the Assignment Group breakdown
Add the Assignment Group breakdown to all three indicators, using the OOB one if it exists in your instance or creating one on the sys_user_group table. This lets you filter the chart to any group.
If you only ever need one group, you can add "Assignment group is [your group]" to the indicator source conditions instead, but the breakdown is more reusable.
Step 4: Collect the data
- Create a data collection job containing the three indicators, scheduled to run weekly (for example at the end of each week).
- For past weeks, run a historic data collection for the Opened and Resolved indicators.
Note that the In Progress indicator is a snapshot of the state at collection time, so it can't be rebuilt accurately for past weeks. It will build up from now on.
Step 5: Create the visualisation
On your Platform Analytics dashboard, add a data visualisation:
- Type: Column (vertical bar)
- Data sources: add all three indicators
- Breakdown: Assignment Group, filtered to your group
- Time period: weekly, for the number of weeks you want to show
This gives you a grouped column chart per week (W45, W46 and so on), with Opened, Resolved and In Progress side by side, like your example.
Alternative without Platform Analytics: a standard report can only trend on one date field. Opened and resolved use different dates, and "in progress" needs a weekly snapshot, so this requirement isn't a good fit for a single report. Platform Analytics is the right tool here.
If this answer helped you, please mark it as Helpful and Accept as Solution so others with the same question can find it.