Open URL

[vsap2000]

Hello Guys,

I have a high level dashboard  with table which checks Curr Mth value against target accordingly it shows traffic light shown below, 

State Name    Curr Mth ($000's)   Target       Target Chk

AL                         6000                        5000           

CA                         4800                         5000                   

NY                         3000                           5000                    

 

For Dot I have used Chr(11044) as measure. 

User like to open an app (using URL) when he clicks on any color for that particular state name, I used following code 

'MY URL/sheet/sheet id/state/analysis'& '/select/' & GetCurrentSelections(']/select/','/[','];[',50) & ']'.

For instance, user wants to know why it's red for NY when they click it should open the app with filter passed for NY. 

With the code above I have to filter  first, on State Name (or couple more fields) and then click on any dot and it opens the app with the filtered state name (or couple more fields). It is 2 step process is it possible it can be achieved with one step? 

Hope to get solution.

Thanks in advance.

-V

[Andrei_Cusnir · Accepted solution]

Hello,

There is a chance that I have misunderstood the use case scenario, however I will share with you my reproduction results and hopefully it helps you get on the right path to the resolution. In my use case scenario I have followed the steps below:

1. I have created an app "App Primary":

As you can see the Table chart looks more or less the same as the table that you have provided in the post.

2. I then have created a new app "App Secondary":

3. If my understanding is correct, you would like to pick a state from Primary App and filter the selections in Secondary App. In that case I have used the following expression for the URL within the Primary App. (I have added the URL on Target field for testing purposes, while changing the Representation from Text to Link) :

='https://<MY_SERVER>/sense/app/<SECONDARY_APP_ID>/sheet/<SHEET_ID>/state/analysis/select/Dim2/b/select/Dim3/Y;Z/select/StateName/' & StateName

Allow me to break down for you how this link works:

1. /select/Dim2/b : Will select the value "b" from field "Dim2"
2. /select/Dim3/Y;Z : Will select the value "Y" and "Z" from field "Dim3"
3. /select/StateName/' & StateName : Will make a selection on field "StateName" and the selection is based on the value of the clicked record from the table. For example if you click on the target of row 1, then the StateName equals to AL so the selection will be applied as /select/StateName/AL and if you click on the target of row 2, then the StateName equals to CA, so the selection will be applied as /select/StateName/CA

4. Here is the result that I get from clicking on the target of the last row:

As you can see the proper selections were applied and because I have clicked the target of StateName NY, then the opened app is filtered based on that StateName.

You don't have to use the GetCurrentSelections() function, because it requires you to do the selections in the app that you are currently working on. Therefore, you have to construct the link differently, with the approach I have mentioned above. When clicked on the row inside the Table chart, you can take the StateName from there, and if you need more filters, you can pass them through that URL as shared in the example. This way, with only one click, you will get a the secondary app open and filtered on needed selections (Without the need to first do the selections and then get the selections with the function)

I hope that this information was helpful. In case I have misunderstood the use case scenario, please elaborate in details by providing additional information. However, if it has helped you resolve the issue, please mark it as accepted solution to give further visibility to other community members.