4 Replies Latest reply on Sep 19, 2017 5:43 AM by Mahfooj Khan

    double aggregation

    oscar vicente

      hi good morning i've the following doubt within tableau and aggregations.

      I've to do the following operations ( described in excel sheet with further details)

      Starting from a 1 to N  relation currently in my DB.

      1.Aggregate ( SUM)  for each unique record value in the dimension  the total  kpi variable im measuring for that  record value.

      2.Based on the new aggregated KPI value per single dimensions value categorize  into 2 different categories.

      3. Show in a graph the number of record per  category per year.

       

      Thanks for your support/ideas in advance.