Page Analyzer Links (or Deep Linking with Filters)

Jessica
Jessica Member
in Charting

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.

Page Analyzer Link.PNG
https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Transforming_Data_Using_Beast_Mode/Sample_Beast_Mode_Calculations%3A_Miscellaneous_Transforms

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

My Example.PNG


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?

Tagged:

Answers

  • GrantSmith
    GrantSmith Coach

    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 Member

    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 Member

    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.

Categories