Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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:
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.
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:
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.