DashBoard

SanakaBharR
Kilo Contributor

Can we create a custom date filter in reports and can we add to dashboard? 

Please suggest...  For reference I am snap.

5 REPLIES 5

BeingKhan
Kilo Guru

Yes — you absolutely can create custom date filters in reports and add them to dashboards, even in the SNAP release. However, there are important constraints you need to be aware of, especially given the age of SNAP compared to modern releases.

Below is a clear, honest, step-by-step explanation, including what is possible, what is not, and practical workarounds that actually work in SNAP.


Short Answer (Executive Summary)

  • ✔️ Yes, custom date logic can be created in reports

  • ✔️ Yes, those reports can be added to dashboards

  • No, SNAP does not support fully dynamic/custom date pickers like modern UI Builder dashboards

  • ⚠️ You must use relative dates, scripted filters, or interactive filters


🔎 Understanding the SNAP Limitation (Important Context)

You are on SNAP, which means:

  • No UI Builder–based dashboards

  • No modern Filter Pills

  • No dynamic “From Date / To Date” user inputs

  • Dashboards rely on classic reporting engine

So we must design within classic capabilities.


Option 1 — Use Relative Date Filters (Most Common & Supported)

This is the recommended approach in SNAP.

Example Use Cases

  • Last 7 days

  • Last 30 days

  • This month

  • Last month

  • Last X days

How to Configure

  1. Go to Reports

  2. Create / open your report

  3. Add condition:

    Date field (e.g. Opened) → Relative → Last → 7 → days
  4. Save the report

  5. Add it to a dashboard

✔️ Works perfectly
✔️ Dashboard-safe
✔️ SNAP-compatible


Option 2 — Use Interactive Filters (Closest to “Custom Date Filter”)

Interactive Filters do exist in SNAP, though limited.

Supported Date Inputs

  • On / Before / After

  • Relative date ranges

Steps

  1. Go to Dashboard

  2. Click Edit

  3. Add Interactive Filter

  4. Select:

    • Table

    • Date field (Opened, Created, etc.)

  5. Attach it to your report

Users can now adjust the date range live on the dashboard.

📌 This is the best approximation of a custom date picker in SNAP.

BeingKhan_0-1767493506029.jpeg

 

BeingKhan_1-1767493506493.jpeg

 

BeingKhan_2-1767493506598.png

 


⚠️ Option 3 — Scripted / Advanced Date Conditions (Power Users Only)

You can use encoded queries with dynamic date logic.

Example

opened_at>=javascript:gs.daysAgoStart(30)

Or:

opened_at>=javascript:gs.beginningOfLastMonth()

✔️ Works in reports
✔️ Dashboard-safe
Not editable by end users
Hardcoded logic

Use this only if:

  • The date logic must be fixed

  • End users do not need control


What You CANNOT Do in SNAP

Be very clear on this:

Feature SNAP

Custom date picker (from/to)
UI Builder filter pills
Dashboard-level date input fields
User-entered date parameters

These arrived much later (Paris → Utah → Tokyo → Vancouver era).


Best Practice Recommendation (Strong Opinion)

For SNAP:

  • Use relative date filters inside reports

  • Add interactive filters for flexibility

  • Avoid scripting unless absolutely required

If users ask for “custom date selection,” explain:

“This instance supports relative and interactive date filtering, not free-form date input.”

That sets the right expectation.


🧠 Decision Matrix (Quick Reference)

Requirement Best Option

Fixed rolling windowRelative date
User-controlled date rangeInteractive filter
Advanced logicScripted query
Free date picker Not supported

ℹ️ Platform Context

All of the above applies to ServiceNow SNAP release and classic dashboards.

 


[ Please Mark my post as helpful & accept it if you find it valuable ]

MD SHADAB KHAN
CSA || CAD || CIS-DISCOVERY
PLEASE MARK THE ANSWER HELPFUL AND ACCEPT IT AS A SOLUTION IF YOU FIND IT HELPFUL & CORRECT

SohamTipnis
Tera Expert

Hi @SanakaBharR ,

 

Yes, you can absolutely add the custom date filter or your own choice; there are some constraints on that, like validity due to scale limit or range.

So before you publish it, please check all the attestations with it.

 

If you find my answer useful, please mark it as Helpful and Correct ‌‌😊

 

Regards,

Soham Tipnis

ServiceNow Developer ||  Technical Consultant
LinkedIn: www.linkedin.com/in/sohamtipnis10

Ankur Bawiskar
Tera Patron

@SanakaBharR 

check these links 

How to create a date range interactive filter for dashboards? 

Date Range filter in a dashboard 

💡 If my response helped, please mark it as correct and close the thread 🔒— this helps future readers find the solution faster! 🙏

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Ankur Bawiskar
Tera Patron

@SanakaBharR 

if you are referring to Platform Analytics dashboard

then In Platform Analytics (PA), you'll get an out-of-the-box (OOB) custom range date filter for dashboards. There's no need to create it from scratch. PFB.
Also check out the youtube video for more details..
https://youtu.be/qEyh-lfvvok?si=ac5PvynaBkdIgidF

Note: if you are still using old reports and dashboards then I recommend moving to Platform Analytics Dashboard

New Platform Analytics: Service Now's Platform Experience Makes Reporting Easy 

💡 If my response helped, please mark it as correct and close the thread 🔒— this helps future readers find the solution faster! 🙏

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader