1 Reply Latest reply: Oct 28, 2015 9:33 AM by Settu Periyasamy RSS

    Grouping Dimension Values for a Funnel Diagramm

    Jan Ellers

      Hi,

       

      I want to create a funnel diagramm to show how deep visitors are digging into the content of the page. The data looks somehow like this:

       

      PagesHits
      www.abc.com/a/slide1.html100

      www.abc.com/a/slide2.html

      90
      www.abc.com/a/slide3.html80
      www.abc.com/b/slide1.html100
      www.abc.com/b/slide2.html90
      www.abc.com/b/slide3.html80
      www.abc.com/c/slide1.html100
      www.abc.com/c/slide2.html90
      www.abc.com/c/slide3.html80

       

      The funnel should only report on slides, so:

       

      Slide1 : 300

      Slide2 : 270

      Slide3 : 240

       

      I first tried it with a dynamic dimension e.g.:

      =If(SubStringCount(Pages, 'slide1')> 0, Pages)

       

      But this is not giving me the results i wanted as this would have three results for Slide1 (www.abc.com/a,www.abc.com/b,www.abc.com/c)

       

      Do you have any ideas how to visualize that?