Changing Parameters after Drilldown

This will require Builder privileges for setup and implementation.

Our Charts/Dashboards have the ability for a Viewer (end user) to select a new parameter value while on a Target or Drilldown Chart/Dashboard without having to navigate back to the Starting Chart/Dashboard. Viewers typically have to drill back-up to the original dashboard to change the parameter being passed to the Target or Drilldown Chart/Dashboard. Having Viewers drill back-up is be a less efficient design.

Understanding Efficient Design

First, in a drilldown, an input parameter can be used in place of a pivot. If you use this method, the filtered field cannot exist as an axis utilizing a pivot. The benefit of this method is that an end user can select a new filter value from the Parameterized Picklist on the Target or Drilldown Chart/Dashboard without navigating back to the Starting Chart/Dashboard as one does with a pivot. This would change the pivots to input parameters on the Target or Drilldown Chart/Dashboard, which allows the designer the set initial values, and if an end user were to open the Target or Drilldown Chart/Dashboard directly the information would still be meaningful.

Selecting a Country as shown in Starting Chart Selection the user will drilldown to a new chart/dashboard and pass the Y₂-value to the Chart/dashboard parameter as shown in Target or Drilldown Chart. If a user opens the Target or Drilldown Chart/Dashboard directly the Initial Value Australia will be filtered on the dashboard. With this method on the Target or Drilldown Chart/Dashboard the end user can select a different filter value directly from the Target or Drilldown Chart/Dashboard without having to navigate back to the Starting Chart/Dashboard as you would with a pivot.

Starting Chart

Starting Chart Selection

Target or Drilldown Chart

Look at the bottom, there is the Parameterized Picklist!

For More Information:

• Input Parameters 11:05
• Multi-Valued Parameters
• Cascading Input Parameters
• Charts: Formatting Parameters
• Dashboard & Chart Design Articles
• iDashboards Builder Manual 8 Designing Charts
• iDashboards Builder Manual 13 Input Parameters

If the above is unable to resolve the issue, then please contact truOI Support for further assistance.