2-tier (Market → County) dashboard filter when Market is a string field and County is a choice list

[Gaganteja]

I’m building ServiceNow dashboards that are used across multiple operational data sources (incidents, change requests, SRUs, alerts, etc.).

In our current data model:

Market is implemented as a string field

County is implemented as a choice list

Both fields exist on a shared entity table and are used for dashboard filtering

Single-level filtering by Market works fine using interactive filters.

However, there is now a requirement for a 2-tier dashboard selection:

Tier 1: Market

Tier 2: County, where the County dropdown dynamically shows only counties belonging to the selected Market

From my understanding, cascading / dependent interactive filters require reference fields with a parent–child relationship, and do not natively support cascading behavior when the fields are string/choice-based.

Given this setup:

Is there any supported way to achieve true 2-tier (Market → County) dashboard filtering when Market is a string field and County is a choice list?

Or is refactoring Market and County into reference (dimension) tables the recommended / only scalable solution?

Are there any platform-supported patterns (without heavy scripting) that work across multiple tables and dashboards?

Looking for best-practice guidance.

Thanks in advance.

[Dr Atul G- LNG]

Hi @Gaganteja 

I doubt it will work, because a string field isn’t easy or precise to use as a filter parameter. You can try this approach and see if it works — otherwise, there’s no real way to do it.

https://www.youtube.com/watch?v=OXqPnHWZL9A

https://www.servicenow.com/docs/r/xanadu/now-intelligence/performance-analytics/c_BreakdownElementFi...