Variable Support
Variables are an important feature and allow the dashboard developer to create a richer end-user dashboard experience. One way variables can be used, is to conditionalize the user interface by hiding and showing different user interface elements or by dynamically changing user filters. Another way variables can be used is in expressions to make them more dynamic.
Hide And Show Chart Example
Chart is only shown when the variable OverviewChart is equal to 2
Button action sets the variable OverviewChart to 2 when clicked
Variable Use In Expression Example
There are two ways of referencing a variable, by name and using macro notation. To reference a variable by name simply type its name and the variable value will be replaced. Macro notation can also be used using the following syntax, $(variablename). Macro notation replaces the variable with its value before the expression is parsed hence allowing you to use variables to contain expression fragments.
Expression Description
Count(Orders.ID, WHERE(Sales.OrderDateYear, CurrentYear)) The variable CurrentYear is replaced with its value after the expression is parsed and is executing.
Count(Orders.ID, $(FilterExpression)) The variable FilterExpression is replaced with its value before the expression is parsed and executed. FilterExpression = "WHERE(Sales.OrderDateYear, 2010)"
if(GetColumn(1) = CurrentYear,Count(Orders.ID), Count(Orders.ID) * 1000) The variable CurrentYear is replaced with its value. If the Chart Dimension of the first column is equal to the value for the variable CurrentYear then Count Orders else Count Orders * 1000
© 2023 - 2024 Flare BI LLC 8 The Green Suite 12605 Dover, DE 19901
Tel: 302-268-8969 Email: