I have a dashboard with a scatter plot, each dot in the scatter plot is a company.
I also have a second dashboard, with both a single-company views (continuous line) and average behaviours across all companies (dotted lines)
I'd like to create an action so that as I click on a company in the scatter plot on the first dashboard, the visualization changes to the second dashboard and the information on the chosen company is displayed.
Is this possible, and if so how can I do it?
in the second dashboard, I used the following trick to visualize single company info:
The measures I show are:
sum([Information]*[singleCompanySelection]) -continuous line
sum([Information]) -dotted line
[singleCompanySelection] is a measure defined as:
IF [company] = [Selected company]
and [Selected Company] is a parameter that allows me to chose a company from a drop-down menu.
So I guess that to achieve my goal, I need to go to the new dashboard AND to choose the value of the parameter when clicking on a company in the scatter plot.
I hope my explanation is clear enough..
The way you are trying to achieve this it is not possible.
You cannot dynamically select a parameter.
If you changed your visualisation so instead of looking at the parameter it was displaying all companies.
You can use an action filter from the first dashboard to filter the second dashboard to only show the company in question