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:
| Pages | Hits |
|---|
| www.abc.com/a/slide1.html | 100 |
www.abc.com/a/slide2.html | 90 |
| www.abc.com/a/slide3.html | 80 |
| www.abc.com/b/slide1.html | 100 |
| www.abc.com/b/slide2.html | 90 |
| www.abc.com/b/slide3.html | 80 |
| www.abc.com/c/slide1.html | 100 |
| www.abc.com/c/slide2.html | 90 |
| www.abc.com/c/slide3.html | 80 |
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?
