Skip to content
Infoveave Learning

Board Expressions

Infoveave Expressions functions are functionalities that allows you to configure special rules for widgets within your Infoboard to create dynamic and interactive data visualizations. With this, you can set conditions over a widget measures and dimension values to control other widgets behavior in your Infoboard.

Expression Syntax

Function(<Reference>,<Condition>) = Conditional Value
  • <Reference> is replaced by 'Widget Name'[Measure Name] and <Condition> is replaced by [Dimension Name] ="Dimension Value".
  • Function: Functions are like commands that you use in data analysis to perform specific tasks.
  • 'Widget Name' is enclosed within single apostrophes (') to indicate it is a string, typically representing a widget name.
  • Measure Name is enclosed in square brackets ([]) to represent a measure name.
  • Dimension Name is enclosed in square brackets ([]) to represent a dimension name.
  • "Dimension Value" is enclosed within double quotes (" ") to represent a specific dimension value.
  • The mathematical operator in the expression establishes the condition.
    • The operator used here is only for demonstration purposes.
  • Conditional Value specifies the value that must be met for the condition to hold true.

Configure Expressions

Note: Please make sure you have a minimum of 3 charts, a check box filter, and a measure label widget configured in your Infoboards.

Follow the below step to learn the process of configuring Infoveave board expressions.

  1. To configure an Expression in Infoveave, navigate to the desired Infoboard under Insights.
  2. Click on the Edit icon to start configuring your board expression.
  3. Navigate to the customization panel and click on the Setup tab.
  4. Within the Setup panel, navigate to the Infoboard option and click on Configure Expression.
    • A pop-up window or Expression editor will appear.

Configure_Expressions

  1. Click on Add Rule to configure a new Expression.
  2. Write your expression following the appropriate syntax. This includes defining measures, dimensions, filters, calculations, and conditions.
    • Utilize functions and operators available within Infoveave to create your desired expression.

Configure Expression

  1. After defining the expression, configure the Action you want to trigger when the condition is met.
    • Actions can include changing widget properties, displaying messages, or triggering other widget actions.
  2. To add another Action, click on Add Action + icon.
  3. Use the radio button to determine the widget’s Visibility.
    • You can choose between options like Show or Hide based on the condition set within the expression.
  4. Assign the action to a specific Option Group. Common option groups include General, Title, and Image.
    • In the General option group, you might find options related to the widget’s overall appearance, such as background color, borders, and shadows.
    • In the Title option group, you’ll find options that pertain to the widget’s title, including text, font size, and alignment.
    • In the Image option group, options are related to displaying images within the widget, covering aspects like image selection, positioning, and size.
  5. Depending on the chosen option group, customization the action under Options. Here’s a breakdown of some common action options:
    • General:
      • Background Color: Determine the widget’s background color.
      • Border: Configure border settings, encompassing color, width, and style.
      • Border Radius: Specify the curvature of the widget’s corners.
      • Shadow: Apply shadow effects to enhance visual appeal.
      • Theme: Implement predefined themes to alter the widget’s overall appearance.
      • Decal: Add decorative elements or icons for visual enhancement.
      • Show Null Values: Decide whether to display null or empty data values.
    • Title:
      • Enabled: Toggle the visibility of the widget’s title on or off.
      • Label: Set the title’s label or text.
      • Word Wrap: Determine whether the title should wrap to the next line when the text exceeds space.
      • Background Color: Define the background color of the title.
      • Decoration: Apply text decorations such as underlining, bold formatting, or italics.
      • Font Family: Choose the font family for the title.
      • Font Size: Define the font size for the title text.
      • Font Color: Specify the color of the title text.
      • Alignment: Set the alignment of the title within the widget.
    • Image:
      • Image: Select an image to display within the widget.
      • Position: Choose the image’s placement within the widget.
      • Repeat: Determine whether and how the image should repeat or tile.
      • Size: Define the image’s dimensions.
  6. To delete any Expression or Action click on the adjacent Delete icon.
  7. Click OK to save the Expression.

Scenario

Example

Imagine you are overseeing an Order Dashboard in Infoveave, where you want to implement a specific action based on a condition using Expressions. In this scenario, the condition is defined as follows: if the sum of online orders for Brazil is less than 150, a particular action should be triggered.

alt_text

Contextual Information:

  • In the dataset used for the Order Dashboard, we want the set the effect on the Online Orders widget. We use the measure [Orders] and the dimension [Country], specifically targeting the dimension value “Brazil.”

Configure Expression:

We can configure the expression as below:

SUMX('Online Orders'[Orders], [Country]="Brazil") < 150

In this expression, we sum up the online orders for Brazil and then check if it’s less than 150. This becomes the condition for our action.

Consider that we want to configure an action that changes the background color of another widget called Online Orders. Here’s how you would do it:

  • Option Group: Select the General option group because you’re customizing the widget’s overall appearance.
  • Option: From the General group, choose the Background Color option. This allows you to specify the background color that the widget should change to when the condition is met.

By selecting the General option group and the Background Color option, you’re precisely defining the Action to your expression’s condition. By these, you can see how to precisely control the behavior and appearance of your widgets, ensuring that your Dashboard provides meaningful insights and communicates important information effectively. alt_text

Conclusion

Infoveave Expressions functions offer a powerful way to create dynamic and interactive data visualizations within your Infoboard. Infoveave Expressions allow you to set conditions over a widget to control other widget behavior. By following the provided syntax and steps for configuring expressions, you can create complex and customized actions that enhance the Infoboard functionality and communicate important information effectively.