remove search terms with visits < x from freeform table

[kcrl]

Hello-

I have a table that shows search terms by visits and conversion. I would like to only show a table with terms that have at least 100 visits and conversion < x I tried the following formula:

https://experienceleague.adobe.com/docs/analytics/components/calculated-metrics/calcmetric-workflow/...

But I cannot remove the zeros from the table. The issue is I want to export a table of 400 keywords with low conversion but high visits.

[yuhuisg · Accepted solution]

As you've discovered, you can't filter by metrics.

This is a common problem with Analysis Workspace. The general workaround is like this:

1. Create a Calculated Metric using the "IF" function that returns 1 or 0 depending on whether your visits/conversions is more or less than 1,000.
2. Add that Calculated Metric to your freeform table.
3. Sort your freeform table by that Calculated Metric.

The end result is that all of the low-value items will be at one end of the table, allowing you to focus on the other data that are high-value. Again, you won't be able to filter by this Calculated Metric.