Returns the specified number of bottom-most rows, in increasing order of rank as specified by an expression.
The following example returns the predicted state of the Bike Buyer column in a singleton query. The query also returns the bottom two least likely states of the Bike Buyer attribute, based on the adjusted probability determined by the PredictHistogram function.
SELECT [TM Decision Tree].[Bike Buyer], BottomCount(PredictHistogram([Bike Buyer]),$AdjustedProbability,2) From [TM Decision Tree] NATURAL PREDICTION JOIN (SELECT 28 AS [Age], '2-5 Miles' AS [Commute Distance], 'Graduate Degree' AS [Education], 0 AS [Number Cars Owned], 0 AS [Number Children At Home]) AS t