Expand my Community achievements bar.

Announcement: Calling all learners and mentors! Applications are now open for the Adobe Analytics 2024 Mentorship Program! Come learn from the best to prepare for an official certification in Adobe Analytics.

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

38 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.