Operations Dashboard bar chart for top (n) results

Idea created by paul.haakma on May 7, 2018
    New
    Score80
    • Craig.Mueller_cadoc
    • gareth.baker_wessexwater
    • mvolz47
    • billfox
    • arepsher
    • paul.haakma
    • eshreve_azdema
    • atamilos

    Currently, in Operations Dashboard there is a widget for bar charts (Serial Chart).

     

    Using Grouped Values to display a 'count' statistic yields a bar chart with a category for each distinct value in the given field. Given a table with hundreds of distinct/unique values, this results in a huge bar chart.

    In my use case, a table contains search terms used. Approximately 10-20 have large numbers of searches, but then it drops off significantly. I want to just restrict the bar chart to show the "Top 10" or equivalent results. Note of course that I want to be able to define how many results/bars I want to display.

     

    The link below is my original GeoNet post asking if it was possible:

     

    https://community.esri.com/message/769612-how-to-get-the-top-n-results-in-a-chart