11 Replies Latest reply on Jul 25, 2018 8:08 AM by Mahfooj Khan

    Getting around Aggregation and Non Aggregation calculations

    Matt Townend

      Hi All, I am new to tableau and slowly getting my head around it. I am developing a workbook and I am building out a calculation which I am struggling with.

       

      Ultimately, I want to take the answer to the below and divide it by the CountD of the Opportunity ID.

       

      { FIXED [Contact Id 18],[Opportunity Id],[datetime]:SUM([Pageviews])}

       

      If I do this in the calculation, then I rightly get a aggregation and non aggregation error message.

       

      Is there a way to convert this calculation?

       

      Many thanks in advance,

      Matt