Visokio website     Downloads     Video tutorials     KnowledgeBase  
Displaying only top x bars on a bar chart? - Visokio Forums
Displaying only top x bars on a bar chart?
  • revlin June 8, 2012 7:02AM
    Hi all - When creating a dashboard with a barchart, I only want to display the top 10 (for example top 10 sales staff) - I do not want the other bar at the end that has xxx others, I only want to present the top say 10. Can this be done?
    Regards,
    Revlin
  • 3 Comments
  •     tjbate June 8, 2012 9:00AM
    Revlin - Assuming you have Order bars set, and the bars are ranked from left to right in descending order, use the Split-by drop down and choose 'Fit to screen' to the right of the measure you are splitting by. This will give you the option 'Exclude values by fixed limit' which allows you to use a slider to set the maximum number of bars to display, e.g. 10 for top 10.
  •     tjbate June 8, 2012 9:10AM
    If you do not want the other values to be grouped into an Other bar, use the small down triangle to the right of the unique values selction to drop-down more options and untick 'Include excluded values grouped as "Other"'.
  • revlin June 8, 2012 9:31AM
    Thank you tjbate. Much appreciated!

Welcome!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership