Unable to sort in Ad Hoc Analysis

Question

When I'm using Ad Hoc Analysis, I try to create a ranked report with different segments as the rows and metrics across the columns. I am able to view the table like I'd expect, however the sort feature seems to disappear. If I put dates (day, week, month, etc) or other dimensions in the row the sort feature is there. I attached two different screen shots to see the missing sort arrows. Does anyone else have this issue?

Thanks!

Gigazelle · Accepted Answer

It looks like the segments being the breakdown is the culprit. I'd expect you should be able to still sort them. I'd recommend filing an incident with Customer Care so we can have a bug created for it. Be sure to include exact instructions on how to duplicate the report, and include the screenshots as well, so there's no reason for the agent to request additional information.

darrynk23768843 · Answer

That is the normalbehaviour for Ad Hoc when you add items to the "Fixed Value List" (if you only have 1 dimension). After you add items, it will immediately use the order that you have put them in to sort the report, and since you don't have any further dimensions to sort on, it won't give you a sort option. The only way to remove this behaviour is to remove all the items from the fixed value list.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded