topic Re: Passing values to another dashboard and using the same in search in Splunk Search

Passing values to another dashboard and using the same in search

smanojkumar — Thu, 19 Oct 2023 12:01:27 GMT

Hi There!
I need to pass a token form one dashboard to another dashboard when clicking its pie chart
Input in dashboard 1

</input> <input type="multiselect" token="choose_office" searchWhenChanged="true"> <label>Front/Back office</label> <choice value="Front Office">Front Office</choice> <choice value="Back Office">Back Office</choice> <initialValue>Front Office,Back Office</initialValue> <default>Front Office,Back Office</default> <valuePrefix>"</valuePrefix> <valueSuffix>"</valueSuffix> <delimiter>, </delimiter> </input>

one of the searches in dashboard 1

`compliance_op` | search office IN ($choose_office$) | chart count by $scope$global | sort $scope$global

My link to next dashboard is

<drilldown> <link target="_blank">/app/SAsh/operational_beautiful?form.choose_office=$choose_office$&form.machine=$machine$&form.origin=$origin$&form.country=$country$&form.cacp=$cacp$&form.scope=$scope$</link> </drilldown>

Multiselect in dashboard 2

<input type="multiselect" token="office_filter" searchWhenChanged="true"> <label>Front/Back Office</label> <choice value="Front Office">Front Office</choice> <choice value="Back Office">Back Office</choice> <choice value="Unknown">Unknown</choice> <prefix>office IN (</prefix> <suffix>)</suffix> <initialValue>Front Office,Back Office,Unknown</initialValue> <valuePrefix>"</valuePrefix> <valueSuffix>"</valueSuffix> <delimiter>, </delimiter> <change> <eval token="office_filter_drilldown">mvjoin('form.office_filter',"&form.office_filter=")</eval> </change> </input>

search in dashboard 2

`compliance_ap` | search office IN ($choose_office$) | chart count by $scope$global | sort $scope$global

I'm facing error in search of dashboard 2.

Thanks!

Re: Passing values to another dashboard and using the same in search

ITWhisperer — Tue, 17 Oct 2023 09:03:07 GMT

Multi-selects settings are passed in URLs by repeating the token with each value that has been selected

Re: Passing values to another dashboard and using the same in search

smanojkumar — Tue, 17 Oct 2023 11:16:46 GMT

Hi @ITWhisperer !

Thanks for your response!

It is working fine, it always selected two values in dashboard 2 even if we are selecting one value in dashboard 1,
For Eg. If we are selecting "Front Office" in Dashboard 1, It shows both values "Front Office" and "Back Office" in Dashboard 2.

Thanks!

Re: Passing values to another dashboard and using the same in search

ITWhisperer — Wed, 18 Oct 2023 08:25:25 GMT

The tokens passed in the url need to be constructed from the multi-select input not hard coded

Re: Passing values to another dashboard and using the same in search

smanojkumar — Wed, 18 Oct 2023 14:04:48 GMT

Hi @ITWhisperer

I tried few way, I didn't got it.

<condition match="isnull($office_filter$) == "Front_Office*""> <set token="office_filter_drilldown">form.office_filter=Front%20Office</set> </condition> <condition match="isnull($office_filter$) == "Back_Office*""> <eval token="office_filter_drilldown">form.office_filter=Back%20Office</eval> </condition> <condition match="isnull($office_filter$) == "Front_Office*" AND == "Back_Office*""> <eval token="office_filter_drilldown">form.office_filter=Front%20Office&form.office_filter=Back%20Office</eval> </condition>

can you please share that as well.

Thanks in Advance!

Re: Passing values to another dashboard and using the same in search

ITWhisperer — Wed, 18 Oct 2023 14:46:09 GMT

Try something like this

<input type="multiselect" token="choose_office" searchWhenChanged="true"> <label>Front/Back office</label> <choice value="Front%20Office">Front Office</choice> <choice value="Back%20Office">Back Office</choice> <valuePrefix>form.choose_office=</valuePrefix> <valueSuffix></valueSuffix> <delimiter>&</delimiter> </input>

Re: Passing values to another dashboard and using the same in search

smanojkumar — Thu, 19 Oct 2023 11:36:54 GMT

Hi @ITWhisperer ,

It is fine but the prefix "form.office_filter=" is affecting the token that is used in search and the link is not expected.

Here is the link

&form.office_filter%3DBack%20Office%26form.office_filter%3DFront%20Office=&

If I'm using this instead, it works

&form.office_filter=Back%20Office&form.office_filter=Front%20Office=&

= is replaced by %3D in first link, & is replaced by %26

Can you please help me in this!

Thanks!

Re: Passing values to another dashboard and using the same in search

ITWhisperer — Thu, 19 Oct 2023 11:57:53 GMT

How are you using the token in the link?

Re: Passing values to another dashboard and using the same in search

smanojkumar — Thu, 19 Oct 2023 12:38:49 GMT

Hi @ITWhisperer

I'm just passing the token in link

$office_filter$

<link target="_blank">/app/SAsh/details?form.compliance_filter=$click.value$&form.timerange=$timerange$&form.antivirus_filter=*&$office_filter$&form.machine=$machine$&form.origin=$origin$&form.scope=$scope$</link>