Expand my Community achievements bar.

Join us January 15th for an AMA with Champion Achaia Walton, who will be talking about her article on Event-Based Reporting and Measuring Content Groups!

Metric Filters

Avatar

Level 8

12/14/18

Hi there,

An idea that would be really useful for us is metric filters/criteria in workspace.

At the moment if you drop an Evar on a free form table you can filter based on values.

What I would love to see is the ability to do this on metrics (greater than / less than) as currently we have to do these reports in report builder / excel.

An (very crude) example of what I am after is below.

Thanks

Dave

Filter.jpg

39 Comments

Avatar

Level 2

5/4/22

It is so disappointing that basic filtering feature needs to be requested to be part of an analytics platform. 

Adding a comment in this thread hoping to be notified when someone from Adobe confirms this is available.

 

The use of "If" statement (+ "and" for multiple conditions) is the only workaround

Avatar

Level 2

8/23/22

I totally agree, and have been fighting this one for over a year now. One suggestion was to use a work around that still leaves, in our case, thousands of rows with 0, this is not acceptable. I can't send an automated report like that to a company owner of a large retail store. It's ridiculous to even consider that and tell them to fix it themselves when they get it. Being able to filter a metric to see results of, as an example, 25 or more should not be hard for an Adobe programmer to implement. If it is, maybe we need a different analytics company.

Avatar

Level 2

1/10/23

@celrod How exactly do you filter a table to show only page URLs that have more than 1000 visits in a specific time frame, considering that segments can be created only hit, visit or visitor level? 

Avatar

Level 1

1/10/23

Correcting my previous comment on this. I 'thought' I could do it with segments, but proved I can't. I am surprised this isn't available. Thanks @ancagoaga 

Avatar

Level 8

3/3/23

I "think" the issue is that API 2.0 can filter on Dimension because like an SQL request they can be added to a filter, but the actual results "Metrics" can't be filtered because they are part of the results / the calculation has taken place. We have python scripts do this very thing (post calculation) but it might be that it is significant to do this to Workspace platform.