Hyperlink between dashboards
I have two portlets, one with a pie chart and another is a list (table).
The pie returns the percentage of projects of a manager by department and the other (table) list all the projects of a manager from all departments.
The idea is to click on a department from the first dashboard (pie) and open the second only with information regarding the department that was cliked in the first dashboard.
I think that to do this the link in the first portlet need to pass the department (by parameter) to the second portlet. The second portlet will receive the parameter and uses it as filter to the query.
Can you help me with this?