I want to create a segment which only displays select pages in a freeform table when the segment is applied.
For example: If Page A and Page B are in Group 1 and Page B and Page C are in Group 2. If I select Group 1 from a Segment drop down ONLY Pages A and B appear in the freeform table. If I select Group 2 from the Segment dropdown ONLY Pages C and D appear in the associated freeform table.
I've tried using the following logic to produce these results:
Page equals Page A
Page equals Page B
Result: The table pulls in ALL pages but assigns Pageviews of 0 to non-referenced pages and Exit Rates of Infinity. This is skewing the column sums for Exit Rate (and other some other metrics) which is incorporating the Infinity into the column average.
How can I create a Segment to ONLY display desired pages? As I using the tool wrong?
Unfortunately you only really have one option available - which is to select the pages, right click on them and use 'Display Only Selected Rows'.
Reason you are getting the extra results (the zero and infinity ones) is because you are making use of a metric that calculates as a percentage. If you remove the Exit Rate metric then only the expected pages will display in your Freeform table.
Adobe, when using a metric that calculates to a % will end up showing data for all results regardless of segment. I am assuming that is as a result a % will always return a value (whether zero, a number or infinity).
As Curtis mentioned it is a result of the exit rate metric. One option is to wrap in a checker to only evaluate rows in which visits is greater than or equal to one.
Then you could choose to not display a value when the result is zero. The rows will be there, but with empty values.
You are going to bump into the same issue regardless with the column sum...because in aggregate exit rate has to be 100% (all visits have an exit).
Great suggestion. Seems like it isn't possible to have the column summary for Exit Rate reflect only the displayed values (I.E - not always display 100% exit rate), however this is good enough for my purposes.
Thanks for your help!