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

4 posts, 1 answers
  1. Frank
    Frank avatar
    9 posts
    Member since:
    Feb 2019

    Posted 19 Mar Link to this post

    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?
  2. Frank
    Frank avatar
    9 posts
    Member since:
    Feb 2019

    Posted 19 Mar in reply to Frank Link to this post

    The pickture
  3. Frank
    Frank avatar
    9 posts
    Member since:
    Feb 2019

    Posted 19 Mar Link to this post

    For the third and last time. The picture does not want ...
  4. Answer
    Silviya
    Admin
    Silviya avatar
    335 posts

    Posted 22 Mar Link to this post

    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
Back to Top