Interactive Filters on Dashboards

[Luke James]

Hello All, 

I have a requirement where the customer on their knowledge dashboard wants to see the stages of a knowledge article based off which knowledge base the article is attached to and it's category. 

I have two interactive filters, one being to select a knowledge base, and the 2nd one to select a knowledge category. 

My question is, how do I ensure that when a knowledge base is selected in the first interactive filter, that in then only shows the KB categories associated with the knowledge base that has been selected? 

Many Thanks, 

Luke

[Luke James]

Good Morning All, 

Thanks for all your replies, been using a cascading filter from the start of trying do this requirement. But on my reports it's just not filtering the results as I need. I have a cascading filter setup to show the knowledge base and then another to display the kb category name. I select a value for each one, but it's just not filtering these results in the reports properly. And I have the reports setup to follow the interactive filters. Any suggestions? 

Many Thanks, 

Luke

[T_Fesenko]

Hi Luke, 

Are those filters references or choice dropdowns? Have you got a interactive filter references defined to specify what tables on what fields must be filtered?  See the screenshot on the article below
Solved: Interactive Filter / Multiple Tables - ServiceNow Community
Best regards, 

Tim

[Luke James]

Hi @T_Fesenko , 

They are cascading filters. I have one cascading filter on table kb_knowledge with a display field of Knowledge base. Then another cascading filter on table v_st_kb_category with a display value of label. 

This gives me the values that I want to display in this interactive filter. But my reports on the kb_knowledge tables do not seem to filter everything as I need it to filter on first knowledge base selection, then the selected category?

Many Thanks, 

Luke

[Luke James]

Thanks everyone, i've managed to fix the issue now. Thanks for everyone's help. 

Kind Regards, 

Luke

[T_Fesenko]

What was the issue though? 🙂