2 Replies Latest reply on Jul 4, 2018 2:35 AM by Matt Lazarus

    Aggregate/Scalar Error Message

    Brent Johnson

      I got a new error this morning:

       

      An error occurred while communicating with the data source.

      Cannot mix aggregate and scalar expressions.

      Unable to calculate the sort for the field 'Dimension'. The display may not show correct data.

       

      Essentially, I have created an overall score metric, which is a rolled up whole number from 0-100 based on a series of metrics that are weighted averages.

       

      This number is correct and can be displayed by various dimensions, but I cannot sort the score based on any dimension without running into this error.

       

      Has anyone encountered this or know of any remedies?