5 Replies Latest reply on May 19, 2014 3:10 AM by Tara Carter

    count or sum uniques based on multiple dimensions

    Tara Carter

      Hi there,

       

      I have a spreadsheet and Tableau Dashboard as attached. Below are an example. image1.jpg

      image2.jpg

      In this example, this page appears several times in a month with different Audience Segments (column C). Tableau is showing 537 Unique Visitors (102+102+102+77+77+77) and 783 Page Views (140+140+140+121+121+121). However, the true totals should be 179 Unique Visitors (102+77) and 261 Page Views (1). That is, a page should be only considered once each month.


      Is there a way to only consider a page once each month? Thanks!