Platform Analytics - Date filter

[Brian Lancaster]

I'm testing Platform Analytics and I'm trying to create date filter. After I set the table none of the system fields like created are available. How can I create a date filter based on created date?

[Pam Reid1]

Did you pick a Date filter and not a single or multi select filter?  Once you pick date you should see the create, closed, etc fields.  one thing we have found though, if you are a report admin but not a system admin, we cannot actually chose the incident or task table for a date filter.  When we choose a date field like created, it just clears it out.  System Admin can do it, but no one else can in our instance.  we haven't been able to figure it out. All other tables work.  of course it doesn't happen in my developer instance 🙂

[Brian Lancaster]

Yes I chose date. But created is not visible in the field list. I know it is there because I'm trying to recreate a Dashboard using demo data in my PDI that is in my instance. Which is not using Platform Analytics.

[vishwajeet5550]

To create a date filter based on the Created date in Platform Analytics, you first need to ensure that the sys_created_on field is available in the table you're w

var filter = new GlideFilter('incident'); 
filter.addQuery('sys_created_on', '>=', '2024-01-01'); 
filter.addQuery('sys_created_on', '<=', '2024-12-31');
var results = filter.getRecords();

orking with, such as Incident or Task. This field is typically a system field that tracks the creation date of records. If it's not appearing in your filter options, it might be due to configuration issues or restrictions in the Platform Analytics setup. Start by selecting the correct table in your report configuration, and when setting up the filter, ensure you choose the sys_created_on field as your date field. If you can't find this field, it may not be indexed or exposed for analytics, in which case you may need to index the field or work with your administrator to ensure it's available. In some cases, you might have to create a custom script to expose the created date for filtering. Additionally, verify that you have the appropriate permissions and roles to access system fields like sys_created_on. If these steps don't resolve the issue, you may need to check the Performance Analytics plugin configuration or reach out to ServiceNow support for assistance in making the field available in your filters.

[Brian Lancaster]

It must be a restriction in Planform Analytics as it none of the system date fields show for any tables I try. Even incident.