Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

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 needs to be sent into the child dasharea.

setup_dataparam4

Below is a list of properties and functions:

PropertyFunction

$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:

setup_dynamiccriterias

If $YEAR is 2012, the formula should return 2011.

Published:

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 needs to be sent into the child dasharea.

setup_dataparam4

Below is a list of properties and functions:

PropertyFunction

$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:

setup_dynamiccriterias

If $YEAR is 2012, the formula should return 2011.

For an optimal Community experience, Please view on Desktop
Powered by Zendesk