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!
Register Here

Data Warehouse Sort by Feature for Metrics

Avatar

Linda58
Level 2

7/28/21

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. 

4 Comments

Avatar

Andrey_Osadchuk
Level 10

7/29/21

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

 

 

Avatar

Linda58
Level 2

7/29/21

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

Avatar

Linda58
Level 2

7/29/21

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

Reply