This is a migrated thread and some comments may be shown as answers.

How can I aggregate by median and mode in the Report Desigener (stand allone)

3 Answers 138 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Frank
Top achievements
Rank 1
Frank asked on 19 Mar 2019, 10:20 AM
Hello,

I have created a report with several groups.
These groups should display different aggregated values.
See picture 1.

Average and number are of course no problem.
But median and mode already rather.
For each group requires an array with the corresponding sorted values for the calculation.

I use the Rport Designer (stand allone) with the Report Server and need an aggregate function for median and mode.
How can I implement this?

3 Answers, 1 is accepted

Sort by
0
Frank
Top achievements
Rank 1
answered on 19 Mar 2019, 10:26 AM
The pickture
0
Frank
Top achievements
Rank 1
answered on 19 Mar 2019, 10:40 AM
For the third and last time. The picture does not want ...
0
Accepted
Silviya
Telerik team
answered on 22 Mar 2019, 07:06 AM
Hi Frank,

Built-in aggregate functions we provide are listed in Aggregate Functions article where median and mode functions are not supported out-of-the-box. You can still create a custom aggregate function and use it inside report expressions. How to implement custom aggregate functions is elaborated in User Aggregate Functions help article.

Note that to use custom functions inside the Standalone Designer it needs to be extended - check Extending Report Designer help article for reference.
You can also log a request into our feedback portal for providing median and mode functions out-of-the-box.
 
Best Regards,
Silviya
Progress Telerik
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Tags
General Discussions
Asked by
Frank
Top achievements
Rank 1
Answers by
Frank
Top achievements
Rank 1
Silviya
Telerik team
Share this question
or