1 2 Previous Next 26 Replies Latest reply on Feb 27, 2015 1:07 PM by Jonathan Drummey

    Aggregating over an aggregate

    Hamish Wilson

      I'm sure this has been asked countless times before but despite extensive google searching I haven't found a sufficient solution to my problem hence asking (sorry!) - I'm very new to Tableau.

       

      I have a data set that resembles the following

      SupplierSpend
      Supplier11
      Supplier22
      Supplier34
      Supplier47
      Supplier510
      Supplier611
      Supplier714
      Supplier85
      Supplier911
      Supplier106

      I want to do the following;

      1. Calculate the highest number in the set (in this case 14)
      2. Work out which quantile each number belongs in (Q1 = 1 - 14/4, Q2 = 14/4 - 14/2, Q3 = 14/2 - 14*(3/4), Q4 = 14*(3/4) - 14)
      3. Aggregate over step 2, to show the frequency distriubution of quantiles

      I used a calculated column with IF .. ELSEIF .. ELSEIF... ELSE.. END to determine part 2 above, but when I try to COUNT to achieve the 3rd part, I'm told I can't aggregate over an aggregate. Is there another much cleverer way to achieve what I want?

        1 2 Previous Next