5 Replies Latest reply on Sep 16, 2013 6:11 AM by Jonathan Drummey

    SUM the top x values

    Markus Ekenberg

      I am creating a dashboard to benchmark individual assets against the group and I want to give the users the option to select top/bottom performers to compare against. I have figured out how to display individual charts for each of the top X by using the index formula but what I really want is to aggregate the data and get 1 chart. Any ideas?

       

      I have dabbled a bit with custom SQL where I use a parameter in combination with LIMIT in the SQL szntax. This works well for 1 chart but for multiple I would need to create a new connection for each chart which I want to avoid. I would prefer a solution done inside Tableau.