5 Replies Latest reply on Feb 10, 2017 8:31 AM by Kate Mahler

    Ranking subcategories and showing top N

    Kate Mahler

      I am trying to rank my attributes per audience segment, and then find what the top attributes are per audience. I am having a bit of a hard time because my audiences are all individual measures, and I need to be able to automate this so that when an audience is chosen, I will see their Top 5 attributes. The closest I was able to get was Editing the filter attribute by "field" and selection what audience I need it done by, but this isn't practical for the automation purpose as our client won't be able to manually change that every time. Does anyone have a work around for this?

       

      I've tried this very helpful article ( Finding the Top N Within a Category | Tableau Software ), but since my Dimensions are "Attribute" and "Measure Names", I am not able to create a combined field so it doesn't work.

       

      I am attaching the packaged workbook here - any and all ideas would be greatly appreciated.

       

      Thanks in advance!

       

      Best,

      Kate