Visit volume filter (why is this so hard?)

[simone89947810]

SO, this seems to have been asked on the forum over and over again based on the search I just did. No answers though....

How can you create a (pretty basic) filter to show only pages with > x visits? I'm particularly interested in doing this in workspace, but any help or advice would be welcome.

Its pretty annoying that such a basic thing which is asked for over and over, with posts going back 5 or 6 years is still not available in what is supposed to be a premium, enterprise level analytics product.

Also.... Report builder for Mac would be nice

[EricMatisoff · Accepted solution]

I'm curious what you're looking to do with this filter, once you have it applied.

Right now, your best option is to leverage Calculated Metrics and sort by them:

Which would result in:

You could also leverage a combination of the IF and GREATER THAN functions if this is your goal. For example, if Visits are greater than 10,000, show Bounce Rate:

Which would result in:

Does that help get you where you're looking to go?

[Jeff-Wright]

Not quite. I'd like the 0 rows to disappear altogether. Reason: When comparing date ranges, the rows with the lowest values have the greatest percentage change. We want filter reports what show only rows with, say, 500 or more visits.

[simone89947810]

Hey Eric,

Thanks for this.

I think the If Then Else might work for what I need. Basically, I have a calculated metric which works out a % of calls generated from each page (Calls / Visits). I want to create a report which I can order by the % column, but exclude any pages with less than say 100 visits or so.

Again, this seems like such a basic thing, while creating the If Then Else might work, it feels like a more complex solution that it should need to be. I’ll give it a try though.

Thanks again!

Simon.

[emiwark]

Hi Eric

Is it possible to have the irrelevant "0" results in your first picture not show up at all? Reason being, I am trying to filter a metric to export the results to a CSV file. I would rather just export a small number of relevant results than a large number which I would then have to take the extra step of manually excluding 0 values.

[Hyder_Ziaee]

Have been thinking about this for a long time as well. I went ahead and created an idea for this.

Allow items with zero value to be not shown in workspace

Hope this helps. Do add if I have missed any details or impact of having the idea implemented or not.

-Hyder

[simone89947810]

I think thats pretty much the same solution, but with some formatting added to the report to remove the 0? Its a good work around, but Adobe should really provide a way to filter by metric volume. Its a pretty simple ask really.