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
  1. Design Workspace
  2. Create Calculated Field
  3. Creating a Formula

Summary Level Option

PreviousRecord Level OptionNextCreating a Range

Last updated 2 years ago

Check out the given illustration on how to create a Formula Field at the Summary level.

The user can also create a formula field choosing the Summary Level as a level option from the Formula field editor window.

  • Access the Create Calculated Field window.

  • Navigate to the Formula tab (It is the default tab).

  • Give a name to the new field.

  • Choose Summary Level from the Level drop-down menu.

  • Select a Save as option (It allows only Measure as the Save As option).

  • Enter a Formula Expression using the Fields and Operators.

  • Click the SAVE option.

  • A new Formula Field gets created and added to the list of dimensions and measures.

Please Note:

  • The Summary level Formula Field only gets saved as a Measure. It can't be saved as a Dimension to the Data Store.

  • Summary Level will not be listed for the space where the MongoDB server is configured in the Admin Settings.