Pie Charts: take top 10 records; sort biggest to smallest

2 posts, 0 answers
  1. Jason
    Jason avatar
    11 posts
    Member since:
    Oct 2012

    Posted 24 Mar Link to this post

    I am struggling to make our pie charts look good and be useful -- here are the two issues (somewhat related):

     

    • The pie chart is connected to the same data source as a crosstab report, with the same groupings. Sometimes there are 20+ rows of data, and I want to display them all in the crosstab, but would like to only display the biggest 10 items on the pie chart, with the rest grouped under "Other." Is this possible?
    • I would like to sort the order that wedges appear in the pie chart by size. Sorting by Field.MyNumber doesn't work because I actually want to sort on Sum(Field.MyNumber), but I get an error from the designer telling me I can't order by aggregate.

     

    Are there solutions to these two items?

     

  2. Ivan Hristov
    Admin
    Ivan Hristov avatar
    85 posts

    Posted 28 Mar Link to this post

    Hello Jason,


    We've answered your inquiry in the support thread you've opened.

    Regards,
    Ivan Hristov
    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
  3. DevCraft banner
Back to Top