Doc Biwee
English
English
  • Presentation of Biwee
  • Get Started
    • Install Biwee
    • Video : My first steps with Biwee
  • Create dashboard
    • Add a visual component
      • Chart
      • Pie
      • Cards
      • Treemap
      • Text Box
      • Pivot Grid
      • Tabs
      • Scatter Chart
      • Gauge
      • Images
      • Grid
      • Range Filter
      • Filter Elements
      • Geo Points Map
      • Choropleth Map
      • Groups
    • Right-click on a component
    • Export a visual component
    • Maximize a visual component
    • Interactivity of a component
    • Data filters in components
    • Dashboard parameters
    • Conditionnal formatting
    • Interactions between dashboard
  • API Integration
  • Data Analyse
    • Performing calculations on data
    • Configure a calculated field
    • Directory of functions
    • Configure calcul in a visual component
    • Aggregate function
      • Aggregations at an intermediate level
      • Usage examples and use cases for the aggr() function
    • Window calculation
  • Settings
    • My account
    • User groups
    • Agent
    • Company settings
    • Options
    • About Biwee
  • Data connection
    • Introduction
    • Database connectors
    • Social network connectors
    • Emailing connectors
    • Files connectors
    • Other connectors
  • Sharing in Biwee
  • Creation of queries
    • Queries on databases
    • SQL Querie parameters
  • Back office biwee
    • User management
  • Changelog
    • Version 3.3
Propulsé par GitBook
Sur cette page

Cet article vous a-t-il été utile ?

  1. Data Analyse

Aggregate function

PrécédentConfigure calcul in a visual componentSuivantAggregations at an intermediate level

Dernière mise à jour il y a 3 ans

Cet article vous a-t-il été utile ?

You can use aggregation functions in calculated fields, in order to evaluate the value of the expression at an aggregated level, rather than evaluated row by row. Calculated fields using aggregation functions can be recognized with the symbol Σ.

Since they are not calculated row by row, these fields do not have a value displayed in the data view of the dashboard. A "!" button indicates that the dataset contains aggregated calculated fields. Their result depends on the data displayed in a visual component.

The aggregation functions are available in the expression editor: