-
1. Re: Action Filter for particular value
Michael Hesser Jun 20, 2016 10:45 AM (in response to Swarup K)Hello Swarup;
Can you provide us with a sample .twbx?
There are many reasons why this functionality might not be working as you expect, however without seeing a sample file it is difficult to diagnose the exact issue.
-
2. Re: Action Filter for particular value
John Sobczak Jun 20, 2016 10:47 AM (in response to Swarup K)If your current action is not working as expected then it's hard to say without seeing how the view/sheet is set up via level of detail If your action filter is defined as "using all fields" (which generally works most of the time) then you might try changing it to a targeted action filter for only that dimension.
-
3. Re: Action Filter for particular value
Swarup K Jun 20, 2016 11:08 AM (in response to Swarup K)Thanks for the response guys. I cannot publish the original workbook due to policies so attaching a sample workbook.
If i click on furniture in dashboard 1 it should navigate to dashboard 2, if i click office supplies or technology it should remain in the same dashboard.
Thanks,
Swarup
-
sample.twbx 1.2 MB
-
-
4. Re: Action Filter for particular value
John Sobczak Jun 20, 2016 11:13 AM (in response to Swarup K)I don't think that is possible using actions. Actions are defined entirely from a source sheet to a target sheet. You cannot have a conditional target sheet or dashboard in your action based on dimension value.
-
5. Re: Action Filter for particular value
Michael Hesser Jun 20, 2016 11:55 AM (in response to Swarup K) -
6. Re: Action Filter for particular value
Joe OppeltJun 20, 2016 11:56 AM (in response to Swarup K)
2 of 2 people found this helpfulAs far as I can tell, you can't make different values or conditions jump to different dashboards, ...
BUT!!!
You can make different things on the SAME dashboard pop out and cover the existing containers, and as far as the user is concerned, he went to a new dashboard.
In this very simple example (see attached, version 9.0 workbook) I make different things pop out based on which value was selected. Select value = 1, and you see a text box pop out. Select 2, and a different text box pops out. Etc.Any object can be popped out, including a whole container (or containers within containers, etc.) designed to look like an entirely new dashboard.
If this will satisfy your needs, I can work with you to implement this.
-
7. Re: Action Filter for particular value
Swarup K Jun 21, 2016 11:13 AM (in response to Swarup K)Thanks Mike, Joe and John for trying. I got a workaround for my requirement, just placing a blank field on the values on the dashboard. But there are few limitations with this approach, it will work for static data and for small amount of data.
Attaching the Twbx for reference.
In the attached workbook action will work only if you click on East region for rest other it will remain in the same sheet only.
Regards,
Swarup
-
sample.twbx 1.1 MB
-