Ascending/Descending under Add view of custom dashboard/report does not sort at all for specific metric.
We try to add as below:
Add view -> Vmware -> Virtual Machines -> Table view -> Next.
Select Name -> expand CPU’s -> Percent Ready Time -> finish.
Under Filter list -> order by: Percent Ready Time, whether we select ascending/descending, it never sorts the list at the bottom.
Limit to 10 items from top is selected.
The list contains almost xxx objects (Virtual Machines) and a lot of them don’t have any value set for that specific metric (more than xxx).
So basically the actual value for the metric is null for those objects.
WCF Query mechanism is used for that drag and drop portlet filter/sorting feature when you use the wizard.
The Query behavior is:
- All those objects with null values are going to show up on top of the list no matter what we’ve set for sort order (ascending/descending)
So when we have the limit to show only 10 item then they are all going to be n/a and doesn’t really matter if we switch the order.
WORKAROUND:
To sort the list at the bottom, when we select ascending/descending for filter list, we need to follow below steps:
( We have used PrecentReady metric as example )
Add View -> Name, CPu's -> PercentReady Time -> Filter.
Order by Cpu's -> Precent Ready -> current -> average.
Limit to 10 items from top.
Match the following rule:
Cpu's -> percentready time-> Current -> average.
is greater than 0.0 % -> Apply.
Now if you switch from ascending/descending, the lists changes accordingly.
Also it is better to be more specific about the metric value when configuring the table and the filter. (cpus/percentReadyTime/current/average)
