How to Filter Pivot Table Based on Date Range Maximum Value in Dashboard
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-16-2025 10:11 AM
I have already created a dashboard in ServiceNow with a date filter and two pivot tables: Old Laptops and New Laptops.
The data source is the cmdb_ci_computer table, which contains an End of Life field.
The date filter allows users to select a range (e.g., 01/01/2014 to 31/12/2025).
Based on the selected date range, any records where the End of Life falls within that range should be included in the Old Laptops pivot table.
The issue is with New Laptops:
It need to include records where the End of Life date is greater than the maximum date in the selected range (e.g., End of Life > 31/12/2025).
What is the best way to implement this logic for the New Laptops pivot table in the dashboard?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
4 weeks ago - last edited 4 weeks ago
Hi @segarenc,
Have you tried a custom interactive filter?
https://www.servicenow.com/docs/bundle/yokohama-now-intelligence/page/use/dashboards/concept/c_Custo...
You can create input fields and use the values inputted to generate a query and apply it to reports on the dashboard.
