Multiple filters in Deep Linking with Filters

TBB_Heather

Hoping there is a syntax error here a fresh set of eyes can find.  Deep linking with filters from one story dashboard to another.

Using one column works perfectly.

adding a 2nd isn't working - error "a problem has occured while loading page filters. if the problem persists contact domo support" (which I did, but unsure if it's truely a domo problem, or a code error)

 

Following the documentation with %22, or using " code as has been recomended in other dojo posts has the same result.

 

THIS (WITH 2 FILTER COLUMNS) DOES NOT WORK

CONCAT('<a href="https://thebluebook.domo.com/page/xxxxxx'

,'?pfilters=[{%22column%22:%22Public/Private%22,%22dataType%22:%22string%22,%22operand%22:%22IN%22,%22values%22:[%22'

,`Public/Private`

,'%22]}]'

,'?pfilters=[{%22column%22:%22State (Proj)%22,%22dataType%22:%22string%22,%22operand%22:%22IN%22,%22values%22:[%22'

,`State (Proj)`

,'%22]}]" target=%22_blank%22>'

,'state, pub/pri'

,'</a>'

)

 

this WORKS:

CONCAT('<a href="https://thebluebook.domo.com/page/xxxxxx'

,'?pfilters=[{%22column%22:%22State (Proj)%22,%22dataType%22:%22string%22,%22operand%22:%22IN%22,%22values%22:[%22'

,`State (Proj)`

,'%22]}]" target=%22_blank%22>'

,'state test'

,'</a>'

)

 

(Used this documentation https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Transforming_Data_Using_Beast_Mode/Sample_Beast_Mode_Calculations%3A_Miscellaneous_Transforms)