Data Warehouse Sort by Feature for Metrics

[#1]

Description - In Data Warehouse I created a report for executives but do not see a feature to "sort by" for the metrics. I need to sort largest to smallest for internal searches. 

Why is this feature important to you - 1. Our executives want an automated emailed report for Internal Search Terms by metric Internal Searches [event]. 2. They want the report to sort by metric Internal searches from highest to lowest. 

How would you like the feature to work - To be able to sort Internal Searches even from highest to lowest to see the search terms at the top that received the most searches. 

Current Behaviour - Currently the report comes in automatically sorted by the dimension name [Internal Search Term]. We need it to sort by those terms that received the most searches first down to the lowest. 

[#2]

I can't believe there is DW report for Executives... DW is designed to export large data sets for further processing.

Consider building a report in Workspace and automate its delivery in PDF. Your executives will be happier

Best wishes,
Andrey Osadchuk | Inspect Launch Implementation, Automate Classifications & Data Sources, Essential Bookmarks

[#3]

@Andrey_Osadchuk Of course, I did that first. The problem is they are trying to review search terms to see what customers are looking for that we don't carry to find new opportunities. Workspace limits to 400 rows when delivered in an autogenerated email. Data Warehouse does not carry that limitation. 

[#4]

@Linda58 , another option is to use the legacy Reports UI where it's possible to export up to 50k rows https://experienceleague.adobe.com/docs/analytics/analyze/reports-analytics/scheduling.html?lang=en

Best wishes,
Andrey Osadchuk | Inspect Launch Implementation, Automate Classifications & Data Sources, Essential Bookmarks

[#5]

@Andrey_Osadchuk Thank you, I will look into that. Since we just entered with Adobe a couple of months ago I'm not sure that the legacy interface is available to me. I was a user of Omniture however from 2006 to 2012 so I am familiar with Site Catalyst and Data Warehouse of the past.