Selection Criteria $ Variables
In addition to parameters in Data Params, there are also some defined variables that can be used in the Selection criteria to return specific values in the generated dasharea.
Dynamic Selection criteria and $ variables
The image below illustrates two different ways of setting dynamic criteria variables. For example, if the selection criteria values are dependent on an end-user selection in a pane, or if a value should be inherited from a linked dasharea, the x-value of a clicked datapoint need to be sent into the child dasharea.
Below is a list of properties and functions:
| Property | Function |
|---|---|
$xval | Inherits the X Column values given in the first dasharea. Should be used if the dasharea is a drill. In other words, if a value from a previous dasharea should be sent into this dasharea. |
$yval | Inherits the Y Column values given in the first dasharea. |
$tag | Inherits the Tag Column values given in the first dasharea. |
$+ControlTag | Inherits the Control Tag from, for example, a selection pane. For example, $DIVISION, where DIVISION is the control tag in the Selection Pane. Can be a selection pane connected to the whole dashboard, or a selection pane in a dasharea that is defined within the same dashboard. |
In addition to the values specified above, the following can be entered in the value field of each selection criteria:
- a Select statement can be written directly in the value field.
- an Excel formula can be written directly in the value field (only applicable from Bizview 2013 version).
- Bizview custom functions can be written directly in the value field. See below for more information.
Dynamic Time Formulas
Create dynamic time formulas by following steps below.
The following parameters need to be defined:
- A time unit within quotation marks, i.e "ISOYEAR".
- A time value. Enter the actual time value that you want to start from, or enter $ + Control Tag to that time value (sent from Selection Pane).
- A number to add or subtract. For example, enter "1" to add one week to the start week or "-52" to subtract 52 weeks from the start.
Enter the formula = select app.f_timeadd('$CLIENT', 'TIMEUNIT','$CONTROLTAG';number) see image below:
If $YEAR is 2012, the formula should return 2011.