Page Analyzer Links (or Deep Linking with Filters)

Jessica

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.

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

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?

GrantSmith

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

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

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.