Skip to Content
1
Jun 17, 2020 at 05:20 PM

SAC - Input control based on linked model

281 Views

Hello,

I am trying to create a story, which contains a chart based on two models. The chart itself is showing information from both models correctly. However, when I try to create an Input control, it does not filter the values within the chart - the chart is rendered blank when any value (other than "all") is selected in the input control.

I tried to switch the models (using linked model as "primary" instead) - this did not help. When I use only one model for the chart, input control is working properly.

To be more specific:

Model 1: Manager Name, Employee Name

Model 2: Employee Name, Total Spend

Link is based on Employee Name (linking on ID).

I would like to choose a manager (in the input control) to see only Spend of Employees reporting to the selected manager in the chart.

Is this even possible? What may be the issue?

Thank you,

Vendula