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,