Page Analyzer Link filter not working - Deep Linking

swagner
swagner Contributor
in Magic ETL

Following the notes on Sample Beast Mode Calculations: Miscellaneous Transforms, the section on Creating Page Analyzer Links (or Deep Linking with Filters).

 

I am having trouble getting this to work - my first thought is there is some minor syntax issue I am blind to right now.  Hoping another set of eyes can help.  The Field Name I am using is "Marketing Parent Name", I have tried with underlines (Marketing_Parent_Name) and without... makes no difference.  Below is the BeastMode (sensitive info replaced with x's).

 

Thanks in advance!

 

CONCAT('<a href="https://mayerelectric.domo.com/page/xxxxxxxxx '

,'?pfilters=[{%22column%22:%22Marketing_Parent_Name%22,%22dataSourceId%22:%22xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx%22,%22dataType%22:%22string%22,%22operand%22:%22IN%22,%22values%22:[%22'

,`Marketing Parent Name`

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

,’Link Display Name’

,'</a>'

)

Best Answer

  • Valiant
    Valiant Coach
    Answer ✓

    Here's a modified version of one I'm using now. 

     

    Hopefully this helps:

    CONCAT('<a href=''https://xxxxxxxxx.domo.com/page/xxxxxxxxx?pfilters=['
    ,'{"column":"Marketing Parent Name","dataSourceId":"xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx","dataType":"string","operand":"IN","values":["'
    ,`Marketing Parent Name`
    ,'"]}]'
    ,'''target="_blank" title="Open in Domo">','Details','</a>'
    )

    Best of luck,

    Valiant

     

    **Please mark "Accept as Solution" if this post solves your problem
    **Say "Thanks" by clicking the "heart" in the post that helped you.

Answers

  • Valiant
    Valiant Coach
    Answer ✓

    Here's a modified version of one I'm using now. 

     

    Hopefully this helps:

    CONCAT('<a href=''https://xxxxxxxxx.domo.com/page/xxxxxxxxx?pfilters=['
    ,'{"column":"Marketing Parent Name","dataSourceId":"xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx","dataType":"string","operand":"IN","values":["'
    ,`Marketing Parent Name`
    ,'"]}]'
    ,'''target="_blank" title="Open in Domo">','Details','</a>'
    )

    Best of luck,

    Valiant

     

    **Please mark "Accept as Solution" if this post solves your problem
    **Say "Thanks" by clicking the "heart" in the post that helped you.

  • swagner
    swagner Contributor

    AWESOME!!!!

  • WizardOz
    WizardOz Contributor

    Hello, Valiant,

     

    I used this to get to a new page, it works perfect.  However, in my new page, I have some cards built from another dataset.  The second dataset has the same column name as the filter, but the cards did not pick up the fitler.  Do you know how to let the fitler also works for the second dataset?

     

    Thank you.

     

    Olivia

  • b_rad
    b_rad Contributor

    What Chart objects can be used for Page Analyzer Links to work? Also anyone tried/ or made it work for multiple fields with multiple values ?

    Thanks in advance.

Categories