Interested in a ServiceNow event built for developers? Registration for now[dev]26 is officially open!

Created field grouping is not working in Platform Analytics

H M Aishwarya1
Tera Guru

Hi,

 

I was building the Backlog Aging view using Platform Analytics, I have used the 'Created' field of Incident table as a group by to show it as a Aging bucket. its not grouping the values. PFA

 

Any suggestions are much appreciated!

 

Thanks.

HMAishwarya1_0-1786562597185.png

HMAishwarya1_1-1786562679826.png

 

2 REPLIES 2

Lakshmi888888
Kilo Guru

Hi @H M Aishwarya1 

The Created field is a Date/Time field, so Platform Analytics will typically group by each unique timestamp unless a time aggregation or bucket is configured.

For a backlog aging view, try one of the following:

  • Use the field's Date Bucketing/Time Series options (Day, Week, Month, Quarter, etc.) instead of grouping directly on Created.
  • Create a calculated field for Age (Days) and then bucket the values (0-30, 31-60, 61-90, 90+).
  • Alternatively, use Opened At Age or a custom aging indicator if the goal is to show backlog age rather than creation dates.

Can you share the configuration of the Group By field (edit icon next to Created)? Specifically, whether any date bucketing or aggregation has been applied. That will help determine why Platform Analytics is treating each date as a separate category.


Please mark this response as Helpful or Correct if it helped.

H M Aishwarya1
Tera Guru

Hi,

 

PFA.. 

HMAishwarya1_0-1786627237401.png