Skip to main content
Solved

Filter a table based on a numeric metric rather than a value


Forum|alt.badge.img+1

I set up a filter to display rows where a numeric metric is greater than a value. Is there any to test the numeric metric against another numeric metric, rather than the value input? 

 

Best answer by Julie Guérin

Hi ​@Kevin Leadbeater 2, 

At the moment, it’s not possible to set up a view filter that directly compares the numeric values of two metrics. I’d recommend submitting a Product Idea with the details of your use case.

As a workaround, you can perform the comparison within a metric, add that metric to your table (hide it from the view), and use it in your view filter.

Hope this helps!

View original

2 replies

Julie Guérin
Employee
Forum|alt.badge.img+9

Hi ​@Kevin Leadbeater 2, 

At the moment, it’s not possible to set up a view filter that directly compares the numeric values of two metrics. I’d recommend submitting a Product Idea with the details of your use case.

As a workaround, you can perform the comparison within a metric, add that metric to your table (hide it from the view), and use it in your view filter.

Hope this helps!


Forum|alt.badge.img+1

Thanks. Good idea to create another metric which can compare 2 other metrics. I will also create a Product Idea.