Self-Service Visualization
  • What is Story?
  • Creating a new Story
    • Accessing the Story Module
    • Create New Story
      • Creating a new Story with an Existing Data Store
        • Creating and Updating Instance
      • Creating a new Story by Uploading a File (CSV/Excel)
      • Creating a new Story based on a Data Sandbox Data Store with Data Preparations
    • Designing a View
    • Saving Multiple Views
  • Design Workspace
    • Dimension Profiling
    • Measure Summary
    • Series Properties
    • Create Calculated Field
      • Creating a Formula
        • Record Level Option
        • Summary Level Option
      • Creating a Range
    • Order by and Limit
    • Adding a Slicer
  • Chart Gallery
    • Mixed chart
    • Area chart
    • Bar chart
    • Bubble chart
    • Column Stack chart
    • Line chart
    • Pie chart
    • Scattered Plot chart
    • TreeMap chart
    • Circumplex chart
    • Pareto chart
    • Semi Gauge
    • KPI Tile
    • KPI Tile: Comparative Tile
    • KPI Tile: Sparkline
    • Map
    • Data Grid
    • Metric Summary
    • Dissolution/Decomposition chart
    • Spider chart
    • Waterfall chart
    • Funnel chart
    • Inverted Funnel chart
    • Heat Map chart
    • Geo chart
  • Storyboard
    • Search
    • Shared Views
    • Live Refresh
    • Export
    • Alert Center
    • Change Theme
    • Data Store Information
    • Options Assigned to a View
      • Analyse
        • Timeline Play
      • Edit
      • Remove
    • Data Interactions/ Data Drills
      • Drill Into
      • Drill Through
  • Applying Filters
    • View Specific Filter
      • Dimension-based View Filter
      • Measure-based View Filter
      • Date-based View Filter
    • Global Filter
      • Exclude from the Global Filter
      • Saving a Global Filter
      • Custom View Filter
      • Like and Not Like Filter Operations
  • Interactions
Powered by GitBook
On this page
  • Properties
  • General Settings
  • View Filter
  • Column Colors
  • Category Axis
  • Primary Value Axis
  • Insights
  1. Chart Gallery

Waterfall chart

PreviousSpider chartNextFunnel chart

Last updated 2 years ago

Check out the walk-through on properties of the Waterfall chart.

A Waterfall Chart is a form of data visualization that helps in understanding the cumulative effect of sequentially introduced positive or negative values. The Waterfall Chart is used to show how an initial value is increased and decreased by a series of intermediate values, leading to a final value.

Best Situations to Use Waterflow chart:

To show incremental changes in the values over time

Properties

General Settings

  • Order: Select a sequence for displaying information.

    • None

    • Ascending

    • Descending

    • Manual Sort: The user needs to sort the dimensions by using the indicator signs manually. By selecting an order (ascending or descending), the user needs to configure the following fields:

      • Order By- Select a value option from the drop-down menu to order the sequence of the data.

      • Limit- Set a number to display the requested data by this limit.

    • Exclude Global Filter: The view gets excluded from the Global Filter condition by putting a checkmark in the box.

    • Enable Base Zero: Base value gets presented from Zero by providing a checkmark in the box.

    • Show Legend: By enabling this option the Legend gets added to the chart.

Please Note: At present the supported Legend Style is Floating only.

View Filter

  • Filter: Select a filter condition using the drop-down menu.

Column Colors

Category Axis

  • Title: Provide a title for the axis

  • Axis Label: Enable the Category Axis label by putting a checkmark in the box.

  • Label Angle: Select a display angle for the axis label.

Primary Value Axis

  • Title: Provide a title for the Primary Value Axis.

  • Axis Label: Enable the Primary Value Axis label by putting a checkmark in the box.

  • Format Type: Select a desired format type from the drop-down menu (the provided options for this field are: None, Auto, Percent, Thousand, Lacs, Crore, Million).

  • Currency Type: Select a currency symbol to be displayed in the view (the provided options for this field are: None, Euro, Rupees, Pound, USD, Yen, Cent).

  • Precision: Set the after-decimal value (It displays up to 5 precision).

Insights

  • Text: Provide any information regarding the chart. If any digit or character is required to be highlighted, put it inside two asterisks. (E.g., *70%* or *skills*).

  • Text align: There are three alignments to align the text.

    • Left

    • Right

    • Centre

  • Position: There are two options to position the text.

    • Bottom

    • Right

The modified chart view after the chart properties gets applied.

Please Note: When the selected Format Type is Percentage, you don’t get the Currency Type field.

Series Properties

  • Click the Series Properties provided next to the measure name.

  • A new window opens.

  • Configure the required details:

    • Aggregation-select an aggregation using the drop-down menu (By default, it displays the second aggregation type which is Sum.)

    • Display Name- provide a name to be displayed in the legend.

  • Click the APPLY option.

  • The configured Series Properties gets applied to the chart.​

​

Select a color from the given choices: Positive, Negative, and Total.​​

​​

​

​​​