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
      1/1/2018A1/Products3
      1/1/2018A1/Products/14
      1/1/2018B2/Products/11
      1/4/2018C3/Help1
      2/1/2018C3/Help/FAQ2
      2/1/2018D3/Products/11

       

      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!