3 Replies Latest reply on Jun 7, 2016 3:34 AM by Mahfooj Khan

    How to create a field using aggregate and non aggregate arguments?

    Sithum Munasinghe

      Hi All,

       

      I wish to create a calculate field using aggregate and non aggregate fields.

       

      In order to build a score value, first I got the mean value of Field_1 and  it become an aggregate field named Field_3. Now  it was multiply by Field_2 which is a non-aggregate field. Tableau gives an error message as "cannot mix aggregate and non-aggregate arguments with this function" as given below. Resultant field should be contained row level values.

       

       

      I have enclosed my sample workbook herewith. Any help on this would be very much appreciated.

       

      Best Regards,

      Sithum.