3 Replies Latest reply: Mar 3, 2017 12:58 PM by Michael Andrews RSS

    Find average in drill down

    Michael Andrews

      Hi, I'd like to find the average of these items I have drilled down. If you look at this data

      sum.png

      I want to find the percentages (even though the column name is average score) here is what i have

      //Count ItemID gets me 318

      COUNT(ItemID) / COUNT({<ItemName = {"=ItemName"}>} ItemID)

       

      Basically, I need to count all items that have the same parent item name