Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!

Custom sorting option in each column individually

Avatar

Level 2

2/28/23

Description -

Why is this feature important to you - To analyze the top internal search terms and match the performance with engagement and order and conversion.

for example- my website's internal search volume are high for many items but the conversion is very low for the high volume search terms. I can see now the top search terms and al add he metrices as i want. But, i want to sort each column separately to set the value like- search terms with a value btw  1000- 5000 and coversion value btw- 0-1 and the table should show only those search terms

How would you like the feature to work -

Current Behaviour -

I can see now the top search terms and al add he metrices as i want. But, i want to sort each column separately to set the value like- search terms with a value btw  

How would you like the feature to work

3 Comments

Avatar

Community Advisor and Adobe Champion

2/28/23

This would be a great feature! Sometimes I want to see stuff like conversion rate for different categories that have between X-Y amount of visits. So being able to filter the metrics for specific values would be fantastic!

The way we're able to filter the dimension down the left of the table, if we have a "filter" for the metrics too would be useful.

Avatar

Level 1

3/29/23

I'm not sure I understand what you mean by sorting each column individually.  It sounds like you want to be able to filter the table based on metric values.  That would indeed be nice. 

If that's what you want then, as a work around, you can use the IF calculated metric function to at sort them to the top.  Something like IF( AND( visits > 1000, visits < 5000), conversion rate, 0 ).  Then, if you sort by that column, the highest converting search terms in the right range will be sorted to the top and everything outside of that range will be sorted to the bottom.  (If you want to sort descending, then you can just change the 0 to a really large number).