Multiple filters in Deep Linking with Filters
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)
