Highly recommend first watching the intro to parameters training video. That will provide the necessary background for the below article.
Filters / parameters can be set via URL using the parameter syntax that is appended to the embed URL (note this only works for explicit scope filters/visuals):
There are 3 types of filters, each of which requires slightly different setup.
Let’s say I have a custom filter (output parameter as report_status) with two possible values – Red or Green.
We can set the default value / pre-selected filter by using the following URL:
@shaun, can we pass corresponding row value through visual url. In below screenshot I have multiple values under subjectid and I have different visual url for each scenario. when I click on first url then it should goes to the url1 visual along with corresponding row subjectid value.
I was trying with below case statement under url field, but somehow it does work. Can explain what is the wrong I am doing.
URL field expression
WHEN [scenario] =‘RB-13’ THEN ‘https://xxxxxxxx.nam.nsroot.net:38888/arc/apps/builder/2166?param.subjectid=[subjectid]’
WHEN [scenario] =‘RB-10’ THEN ‘https://xxxxxxxx.nam.nsroot.net:38888/arc/apps/builder/2175?param.subjectid1=[subjectid]’
ELSE ‘https://xxxxxxxxx.nam.nsroot.net:38888/arc/apps/builder/2160?param.subjectid=[subjectid]’ END as ‘URL’
@Ganesh good question.
You need to use the string function concat() to merge the static base URL with the column value.
I would modify the calculation expression to look like this:
WHEN [scenario] ='RB-13' THEN concat('https://xxxxxxxx.nam.nsroot.net:38888/arc/apps/builder/2166?param.subjectid=',[subjectid])
WHEN [scenario] ='RB-10' THEN concat('https://xxxxxxxx.nam.nsroot.net:38888/arc/apps/builder/2175?param.subjectid1=',[subjectid])
END as 'URL'
Thank you again, I was trying the same before I posted the query but any how it worked now. This would help us to navigate multiple dashboards from summary.
It works great, is it possible to use a link generated this way behind an image, so it works like some kind of button
thanks again for your help!!
@Carlos_Bocanegra you can use any arbitrary HTML in the table field, for example this would produce a button link:
'<a href="https://google.com" class="btn btn-info" role="button">Link Button</a>' as 'link'
Note - make sure to enable HTML in the settings
This is great!! is it possible to mix both solutions so using the dynamic links to point to dashboard filtered based on parameters in the URL and this kind of visualization?
I tried with a custom filter + multiple choice parameter but does not work. Could you take a look?
…concat(…¶m.parent.data="" ‘,’<parent.data:"">’ …)
@Julian you will have to provide more information like export of the dashboard, what you are seeing, and trying to achieve.
I’m trying to set multiple items through a URL.
These items are based on a parameter I created ‘<>’ .
When the filter that is connected to that parameter sets multiple values the result is an error.
I tried concatenating the values with the parameter items.
In the last part I did: …¶m.parameter.data=parameter.data:’’
With no results.
Hope everything’s going fine, also similarly to what others has asked it is working fine for single but not for multiple items, I’m using the following formula
max(concat(‘https://…nam.nsroot.net:123/arc/apps/appgroup/456?initialapp=15433&sheet=1¶m.region.data=’, <<region. data:>>,’¶m.region.exclude+in’))
but I’m getting the following output:
so it doesn’t work, I guess because items are not being separated and enclosure between quotes, I tied putting quotes around the parameter but then it doesn’t return anything.
thanks in advance for your help
@Carlos_Bocanegra the formatting is your post is hard to follow. Not sure what exactly
you expect as the final URL.
Might want to use the code formatter to make it easier to see what you are doing.
@shaun thanks for your answer also I’m adding some images that may show the issue more clearly
the formula I’m using is
and the output
then when clicking the link the url shown on the browser is something like this
thanks in advance