4 Replies Latest reply on May 8, 2018 3:14 AM by Matt Townend

    Tableau Beginner - Need help with Aggregated and Non Aggregated calculation error

    Matt Townend

      Hi everyone,

       

      I have been using Tableau for just a couple of weeks and I have been told the community is a great place for help useful tips and information.

       

      I have a question, how do I fix the attached?  It says I cannot mix an aggregated and non – aggregated comparison, which I get I cannot do.

       

      However, I cannot created a solution. What I want to do is a distinct count the Custom Dimension 1 (which is a Dimension) if the sessions (measure = no. of sessions in a month) is greater than the Avg Session User Toggle (Float parameter I created (1 – 25).

       

      I have attached the error message below.

       

      Any help would be great. Thanks. Matt