Then select the sales year(s) you want to include. Want to try it? In the example below, click the Year list control.
SIGMA CLIENT CONTROLS UPDATE
If you are viewing an existing workbook, without permission or intention to edit, all you really need to know is that inputing a value into a control element will automatically update the data displayed in any elements targeted by that control.Ĭhanging a control's input value without actively publishing the workbook only affects your current view of the workbook and its data. If you are authoring or editing a workbook with controls, you should have a basic understanding of how controls are constructed and how they impact targeted data elements. What does this mean for me? As a Workbook Editor A parameter can be used to quickly track this variable value and inject it into formulas. This allows you to dynamically replace constant values used in calculations across your workbook.įor example, you may want to compare product sales growth by a variable 2%, 5%, and 10% percent. Parameters are excellent for What-If Analysis and User Input Analysis.Ī parameter is a customizable field that can be added to a workbook and referenced in formulas.
When a control's input is changed, the data in its target(s) reacts accordingly. Targets: Targets are the data elements that a control element points to. Together, a control's type and settings define how that control displays on the page and what user input value(s) it will accept. For example, lists require source data but date ranges do not. Settings: Settings are defined by workbook editors and vary depending on control type. Learn moreĬontrol elements can be added to a workbook to manipulate that workbook's data based on user input.Įach filter-based control element has three primary components that define the control: type, settings and target.Ĭontrol element type: A few examples of control types List Values, Date, and Number.
Workbooks support three element types: data elements, UI elements, and control elements.Ĭontrol elements and data elements work hand-in-hand to get the data you want in front of you.
0 kommentar(er)
