7 Replies Latest reply on Jun 30, 2016 6:31 AM by Justus Niemzok

    How to create bins of aggregated field?

    Harshal Bhavsar

      Hello Guys,

       

      I have two columns in my data 'Customer Name' and 'Transaction ID'. I have created two calculated fields one is Cust_Count = CountD([Customer Name]) and another one is Trans_Count = CountD([Transaction ID]). Based on these calculated fields I have created a simple view stating Customer Name and their Transaction Count (Kindly refer attached twbx file). Now I want to create another view to identify how many customers (Customer Count) has 22 transaction Count and how many has 21 transaction count.

       

      Trans Count is an aggregated hence its not giving an option to create bins. So any one can help me out in this?

       

      Regards,

      Harshal Bhavsar

      +91 9867994238