DevExpress Dashboard - Calculated Fields at the Summary Level (Coming soon in v15.1)

Thinking Out Loud
01 June 2015

The upcoming release of DevExpress Dashboard includes the ability to use aggregate functions when constructing calculated field expressions. As you know, aggregate functions perform calculations on a set of values and return a single value. This allows you to pre-aggregate data source field values in a calculated field expression. The resulting calculated field is similar to a measure in multi-dimensional data sources such as OLAP cubes.

You can use any of the following predefined aggregate functions within the Dashboard Designer...

  • Avg() - Returns the average of all values in the expression.
  • Count() - Returns the number of values.
  • CountDistinct() - Returns the number of distinct values.
  • Max() - Returns the maximum value across all records.
  • Min() - Returns the minimum value across all records.
  • Sum() - Returns the sum of all values.

Let's quickly review how you can create a calculated field...Step 1 is to add a new field using the Field List's context menu.

DevExpress Dashboard - Caluclated Fields

In step 2, you must construct the expression using the DevExpress Expression Editor -  In this example, we'll navigate to Aggregate Functions and construct the following expression: Sum([Profit]) / Sum([Revenue])

DevExpress Dashboard - Expression Editor

Once the expression is complete, you can rename the calculated field. In our example, we'll rename it to Margin. 

At this point, you can simply drag and drop the new field to the desired Dashboard item. In the following example, we use Dashboard Cards to visualize the data..

.DevExpress Dashboard - Calculated Fields and Expressions

So what do you think - how likely are you to use this new feature? We'd love to hear your thoughts.

5 comment(s)
Maxime Savard 3
Maxime Savard 3

YES!!!!! lol not other word

1 June, 2015
Muhammad Idrees Khan
Muhammad Idrees Khan

its relly Awsum

1 June, 2015
Santiago Moscoso
Santiago Moscoso

Just Nice!

Is there something similar for Reports and Pivots?

1 June, 2015
Marco Torregrossa (Global)
Marco Torregrossa (Global)

Fantastic!

It's what I'm waiting for!

I will test it as soon as possible

4 June, 2015
qakmak
qakmak

The problem is It can't calculate if there is no any data in the List. But the worst thing is you guys even don't repair it, just tell me I'm not using in right way. and I still need to use parameter to replace it.......

17 September, 2015

Please login or register to post comments.