Page Analyzer Links (or Deep Linking with Filters)

I am trying to create this BM calc but instead of the example shown in DOMO where you create a column with the link (Deep Link Col3) and also display the value (Owner Name Col1) I am trying to do it as one column but I am getting an error on the card. The link takes you to the page and you can see the filter is added to the page but the card has an error.

My table is really a list similar to the one above but I transposed it across in a mega table


CONCAT('<a href="https://xxxxxxxx.domo.com/page/xxxxxxxxxx',

'?pfilters=[{


%22column%22: %22Line of Business Level 3%22,

%22dataSourceId%22: %228377d31b-580b-473f-bbe5-956b70277394%22,

%22dataType%22: %22string%22,

%22operandtype%22: %22IN%22,

%22values%22: [%22',`Line of Business Level 3`,'%22]

}]"

target=%22_blank%22>'

,`Line of Business Level 3`,'</a>')

What am I doing wrong?

Answers

  • GrantSmith
    GrantSmith Indiana 🔴

    Hi @Jessica

    Have you tried compressing the pfilters to be on a single line instead of multiples?

    Also, try target="_blank" instead of URL encoding the quotes target=%22_blank%22

  • Jessica
    Jessica ⚪️

    Changed it to this, still error


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

    '?pfilters=[{

    %22column%22: %22Line of Business Level 3%22,%22dataSourceId%22: %228377d31b-580b-473f-bbe5-956b70277394%22,%22dataType%22: %22string%22,%22operandtype%22: %22IN%22,%22values%22: [%22',`Line of Business Level 3`,'%22]

    }]"

    target="_blank">'

    ,`Line of Business Level 3`,'</a>')

  • Jessica
    Jessica ⚪️

    On this issue, I found that from DOMO support my code was actually working but that we are experiencing a caching issue that is being addressed.