14 Replies Latest reply on May 19, 2016 12:33 AM by siva goberu

    cannot mix aggregate and non-aggregate comparisons or results in IF Functions

    siva goberu

      Hi  All,

      I connected to google analytics data source and trying to generate reports.

       

      when i am trying to run the calculation as shown below .

       

      Calculation:

      IF

      ([Date]) >= [start_date] AND

      ([Date]) <= [Date_Parameter]

      THEN

      ([Bounce Rate])

      END

      ERROR  : (cannot mix aggregate and non-aggregate comparisons or results in IF Functions)

       

           I tried with ATTR(Expression) for the calculation,

       

      IF

      ATTR([Date]) >= [start_date] AND

      ATTR([Date]) <= [Date_Parameter]

      THEN

      ([Bounce Rate])

      END

       

      Calculation is valid but calculation field is not displaying any data

       

      Fields Description :

      Date- Date Field.

      Bounce Rate - Aggregated Field

      start_date -  DATETRUNC('month', [Date_Parameter])

      Date_Parameter - Parameter Control.

       

      Please help me on this

       

      Regards,

      Siva