4 Replies Latest reply on Apr 4, 2018 10:21 AM by Gerardo Varela

    Table calculation: tally across all rows where this row is a substring

    M V

      In 10.4, I want to include a metric to measure page through traffic: % of visitors and page views who saw this page vs (all pages whose branch starts from this one).



      DateUser IDPagePage Views


      So for January: I want to say that "/Products" got 3 page views from one visitor ID (A1), and also that "/Products[/anything]" got 8 page views from 2 visitors (A1 & B2).  That way I could see that about half of its relevance is from subpages.


      If it matters, data source is an extract from Excel, which has grown to over a million lines via multiple months of refreshes.


      Thanks in advance!