Page Analyzer Links (or Deep Linking with Filters)

Jessica
Jessica Contributor

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

  • 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

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • Jessica
    Jessica Contributor

    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 Contributor

    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.