ValQ - Plan
FormulaProductChangelogStart Trial
  • Introduction to ValQ
    • Get ValQ
    • The ValQ Workflow
  • Model
    • Get Data
    • Create Model
      • Dynamic Model
      • Custom Model
      • Import a Model
    • Model Editor
      • Node Operations
      • Editor Features
    • Node Settings
    • Templates
      • Apply Template
      • Manage Template Nodes
      • Import Template
      • Export Template
    • Formula Functions
      • Logical Functions
        • IF
        • SWITCH
        • AND
        • OR
        • NOT
        • XOR
        • IFNAN
      • Math Functions
        • SUM
        • SUBTRACT
        • PRODUCT
        • DIVISION
        • AVERAGE
        • AVERAGEEXZERO
        • AVERAGEEXNEG
        • AVERAGEEXZERONEG
        • COUNT
        • ABS
        • MIN
        • MAX
        • POWER
        • SQRT
        • EXP
        • LOG
        • ROUND
        • FLOOR
        • CEILING
      • Finance Functions
        • IRR
        • NPV
        • PMT
        • IPMT
        • FV
        • PV
        • CUMIPMT
        • CUMPRINC
        • RATE
      • Range Functions
        • RANGE
        • LastNPeriods
        • Get
        • ForEach
        • findByTitle
        • GETCURRENTRANGE
        • GETROWVALUE
        • THIS_SOURCE_KEY
        • PERIOD_LOOKUP
        • PRIOR_SERIES_PERIOD_LOOKUP
      • Static Identifiers
        • THIS/ME
        • CURRENT_SERIES*
        • CURRENT_SERIES_ID*
        • CURRENT_PERIOD_INDEX
        • CURRENT_NODE_VALUES
        • DS.SERIES
      • Node Properties
        • Node Properties Explanation
    • Global Settings
  • Plan
    • Create New Plan
    • Time Series Forecasting
    • Allocation Features
      • Goal Seek
      • Distribute
      • Copy to Periods
    • Driver Based Planning
      • Enabling Driver Based Plan
      • Configuring Driver Inputs
      • Bulk Configuration of Drivers
    • Plan Interface
  • Simulate
    • Create a Scenario
    • Perform Simulations
    • Manage Scenarios
    • Simulation Interface
    • Add Notes
    • Compare Scenarios
    • Scenario Analysis by Node
    • Create Initiatives in a Scenario
      • Steps to create initiatives
    • Create your Presentation
    • Understanding the Node Components
  • Report
    • Variance Analysis Report
  • ValQ Premium FAQs
  • Glossary
  • Resources
  • Release Notes
Powered by GitBook
On this page
  1. Simulate

Understanding the Node Components

PreviousCreate your PresentationNextReport

Last updated 1 year ago

Nodes are the building blocks of the hierarchical tree/table model.

In the tree view, just like a tree, there is a top node that branches out to multiple nodes. Each node represents a value driver or a KPI or a category name along with several performance metrics.

In the table view, the nodes are presented in the form of a hierarchical table with total and individual period values, in which the levels can be expanded or collapsed.

In this section, let's see about the components of a node in detail.

S. No.
Component
Description

1

Node Name

Every node is identified by its name which can be a value driver or a KPI or a category name.

2

Node Value

The primary value in the node is the baseline value which is the total of the node's baseline series. On a simulated node, this value represents the simulated value.

3

Absolute Variance

Absolute Variance is the difference between the Baseline Series and Comparison Series in absolute numbers. On a simulated node, it represents the difference between the Simulated Series and Comparison Series in absolute numbers.

4

Percentage Variance

Percentage Variance is the difference between the Baseline Series and Comparison Series in percentage. On a simulated node, it represents the difference between the Simulated Series and Comparison Series in percentage.

5

Sparkline Chart

A sparkline chart is available on each node which shows the trend. On simulation, the chart changes dynamically to show the new trendline as a solid line along with the old trendline as a dotted line.

6

Conditional Formatting

A color band is present at the top of the node which indicates favorable or unfavorable value or variance, if configured in the node settings window for that node.

7

Simulation-disabled icon

Note:

Baseline series is the primary series on which the simulations are performed.

Comparison series is the series against which the Baseline is compared. It is optional to have a comparison series while creating a scenario.

In the below image, there are two series available, Baseline and a Comparison.

  • Baseline and Comparison series can be a data series or any plan series that has been created by the user.

  • Simulations are done on the baseline series only.

  • You can have no comparison series, or you can have any existing series as a comparison series that you can pick from the dropdown.

Other Pop-up Features

This symbol on a node indicates that the node is disabled for simulation and the node value can not be simulated. Note: To enable simulation for a node, go to the section of the Node Settings window and change the Simulation Method from None to any other method.

Let us see some more features that pop-up when you hover your mouse over the nodes. There are three options available in the top right corner: , and a three-dot dropdown menu. Within the menu we have Edit Node, and options.

Node Components
Baseline and Comparison Series
Node-Other Components
Simulate
Focus Node
Add Note
Add to KPIs
Add to Key Inputs