<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>question KPI reporting - chart type in Community Central forum</title>
    <link>https://www.servicenow.com/community/community-central-forum/kpi-reporting-chart-type/m-p/3622012#M8254</link>
    <description>&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;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?&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="rdevi_0-1794910359209.png" style="width: 999px;"&gt;&lt;img src="https://www.servicenow.com/community/image/serverpage/image-id/535771iC8EFFED9B3F50A44/image-size/large/is-moderation-mode/true?v=v2&amp;amp;px=999" srcset="/community/image/serverpage/image-id/535771iC8EFFED9B3F50A44/image-size/large/is-moderation-mode/true?v=v2&amp;amp;px=999 1.0x" role="button" title="rdevi_0-1794910359209.png" alt="rdevi_0-1794910359209.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Tue, 17 Nov 2026 10:13:05 GMT</pubDate>
    <dc:creator>rdevi</dc:creator>
    <dc:date>2026-11-17T10:13:05Z</dc:date>
    <item>
      <title>KPI reporting - chart type</title>
      <link>https://www.servicenow.com/community/community-central-forum/kpi-reporting-chart-type/m-p/3622012#M8254</link>
      <description>&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;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?&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="rdevi_0-1794910359209.png" style="width: 999px;"&gt;&lt;img src="https://www.servicenow.com/community/image/serverpage/image-id/535771iC8EFFED9B3F50A44/image-size/large/is-moderation-mode/true?v=v2&amp;amp;px=999" srcset="/community/image/serverpage/image-id/535771iC8EFFED9B3F50A44/image-size/large/is-moderation-mode/true?v=v2&amp;amp;px=999 1.0x" role="button" title="rdevi_0-1794910359209.png" alt="rdevi_0-1794910359209.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Tue, 17 Nov 2026 10:13:05 GMT</pubDate>
      <guid>https://www.servicenow.com/community/community-central-forum/kpi-reporting-chart-type/m-p/3622012#M8254</guid>
      <dc:creator>rdevi</dc:creator>
      <dc:date>2026-11-17T10:13:05Z</dc:date>
    </item>
    <item>
      <title>Re: KPI reporting - chart type</title>
      <link>https://www.servicenow.com/community/community-central-forum/kpi-reporting-chart-type/m-p/3622045#M8255</link>
      <description>&lt;P&gt;&lt;SPAN&gt;Hi &lt;a href="https://www.servicenow.com/community/user/viewprofilepage/user-id/346272"&gt;@rdevi&lt;/a&gt;&amp;nbsp;,&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;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:&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;Step 1: Create the indicator sources (weekly)&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;Go to Platform Analytics Administration &amp;gt; Indicator Sources and create three, all on the Incident table with Frequency = Weekly:&lt;/P&gt;&lt;UL&gt;&lt;LI&gt;Incidents opened weekly. Condition: Created on This week&lt;/LI&gt;&lt;LI&gt;Incidents resolved weekly. Condition: Resolved on This week&lt;/LI&gt;&lt;LI&gt;Incidents in progress weekly. Condition: State is In Progress&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;Platform Analytics evaluates relative conditions such as "This week" against the collection date, so each score covers the correct week.&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;Step 2: Create the indicators&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;Create one automated indicator for each source:&lt;/P&gt;&lt;UL&gt;&lt;LI&gt;Number of opened incidents (Aggregate: Count)&lt;/LI&gt;&lt;LI&gt;Number of resolved incidents (Aggregate: Count)&lt;/LI&gt;&lt;LI&gt;Number of in-progress incidents (Aggregate: Count)&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;Set Frequency = Weekly on each.&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;Step 3: Add the Assignment Group breakdown&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;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.&lt;/P&gt;&lt;P&gt;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.&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;Step 4: Collect the data&lt;/STRONG&gt;&lt;/P&gt;&lt;UL&gt;&lt;LI&gt;Create a data collection job containing the three indicators, scheduled to run weekly (for example at the end of each week).&lt;/LI&gt;&lt;LI&gt;For past weeks, run a historic data collection for the Opened and Resolved indicators.&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;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.&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;Step 5: Create the visualisation&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;On your Platform Analytics dashboard, add a data visualisation:&lt;/P&gt;&lt;UL&gt;&lt;LI&gt;Type: Column (vertical bar)&lt;/LI&gt;&lt;LI&gt;Data sources: add all three indicators&lt;/LI&gt;&lt;LI&gt;Breakdown: Assignment Group, filtered to your group&lt;/LI&gt;&lt;LI&gt;Time period: weekly, for the number of weeks you want to show&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;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.&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;Alternative without Platform Analytics:&lt;/STRONG&gt; 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.&lt;/P&gt;&lt;P&gt;If this answer helped you, please mark it as Helpful and Accept as Solution so others with the same question can find it.&lt;/P&gt;</description>
      <pubDate>Tue, 17 Nov 2026 11:33:07 GMT</pubDate>
      <guid>https://www.servicenow.com/community/community-central-forum/kpi-reporting-chart-type/m-p/3622045#M8255</guid>
      <dc:creator>HasanM</dc:creator>
      <dc:date>2026-11-17T11:33:07Z</dc:date>
    </item>
  </channel>
</rss>

