Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Custom Sorting

Avatar

Avatar
Boost 50
Level 4
mikesukmanowsky
Level 4

Likes

65 likes

Total Posts

7 posts

Correct Reply

0 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 10
View profile

Avatar
Boost 50
Level 4
mikesukmanowsky
Level 4

Likes

65 likes

Total Posts

7 posts

Correct Reply

0 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 10
View profile
mikesukmanowsky
Level 4

06-05-2011

There are some similar posts that seem to be discussing this but I haven't seen one that seems to capture the need that everyone seems to have.

 

When looking at a report, it would be helpful to have the ability to define a custom sort order for that report based on the dimension.

 

Most basic use case is I have a prop where I'm storing "Time of Day" in 30 minute increments. The default sorts right now only allow by metric which isn't useful when I'm trying to examine a time part from 00:00 to 23:30.  

 

Another might be "Day of Week" where the sort order is not alphabetical on the dimension but custom {Sunday, Monday, Tuesday, ...}.

 

In order to make this pretty flexible but not overbearing, perhaps Omniture should have a few basic sorts defined (like those above) and then the ability to define a custom sort order which would allow a user to input some sort() function which compares two strings which would represent dimension values and then returns less than, equal to or greater than (-1, 0, 1).  

 

Users could then define what ever they want when it comes to sorts and could possibly include metrics as well:

 

function sortExample1( row1, row2 ) {

 

    var daysOfWeek = ["sunday", "monday", "tuesday", "wednesday", "thursday", "friday", "saturday"];
    return daysOfWeek.indexOf(row1.dimension) - daysOfWeek.indexOf(row2.dimension);

 

}

 

mike