Aggregate functions for Board Cubes

Oliver Röll · 2025-07-02T14:24:02+00:00

There was an error rendering this rich post.

Hi,

if you display a Board cube in a DataView and group it by an entity, then a sum is always formed for the values from the cube.

Is there also a way to form an AVG(), MAX() or MIN() on the individual values instead of the sum, so that an average or a maximum value is obtained from the individual cube values?

I would like to map the SQL aggregate functions to the database columns via a cube.

Is this possible?

Find more posts tagged with

Capsules

Data Modeling

Dataview

Board

Accepted answers

All comments

Helmut Heimann

Hi @Oliver Röll ,

one possibility is using the aggregation, the other possibility is Nexel

Best,
Helmut

Oliver Röll

Hi Helmut,

thank you for your reply.
Where can I find the functionality from your hardcopy?
I haven't found it in Board yet.

Helmut Heimann

Hi @Oliver Röll ,

you can find the settings in the Layout Editor → Data Blocks → Aggregation

In the manual, you'll find the according paragraph here

Capsules → Screens → Objects → The Layout Object → Data Blocks → Block Settings.

If you can't find in your Layout Editor that may be related to your current release.
In that case you might want to use Nexel for the calculation.

Best,
Helmut