Auction Item Numbers

Definition: This base rule is used with auctions only. Returns people with the number of bids, wins, or awards as specified by the arguments in the period defined by From and Through.

Return value: Values of type number

Source: Auctions

From: This field is required. It defines the start of the time frame in which to look for bid/win/award dates.

Through: This field is required. It defines the end of the time frame in which to look for bid/win/award dates.

Arguments Value
Aggregate
  • COUNT- counts the number of bids/wins/awards in the period defined by From and Through [used with Limit by AUCTION, PLAN, GROUP]
  • SUM- sums the values of the of bids/wins/awards in the period defined by From and Through
  • MIN - looks for the minimum value of the of bids/wins/awards in the period defined by From and Through (do not use this option - use BEST instead)
  • MAX- looks for the maximum value of the of bids/wins/awards in the period defined by From and Through
  • BEST - use with auctions with a Preference Bid Method to find the lowest bid value [not used with Queue Bid Method] (Default value)
  • <NOTHING> - returns the target value for the bid/win/award value associated with the target auction item only.
Target
  • BIDS- looks for the date the bid was placed
  • WINS - looks for the date on which the person won number.
  • AWARDS- looks for the date the person was awarded the auction item
Limit by Target
  • AUCTION - limit by auction
  • PLAN- limit by Bidding Plan
  • GROUP - limit by Bidding Groups
  • ITEM- limit by auction item (Default value)
Limit by Gray Number
  • <NOTHING> - do not limit.
  • <INTEGER>- looks for bid/win/award dates limited by the above value identified by its Unique Identifier
  • 0 - A zero looks for bid/win/award dates limited by the above value that match the target value
Limit by Bid Turn Limit selections to Target for a specific bid turn. Positive number is a specific bid turn and negative number is a relative bid turn. Select one or more choices:
  • <NOTHING> -do not limit
  • <INTEGER> -Positive number is a specific bid turn. Negative number is a relative bid turn.
COUNT once per parent offset
  • <NOTHING> -do not limit
  • <INTEGER> -If Aggregate is COUNT, then you can use this value to limit to count only once per relative parent (Default value)
Limit by Min Bin Value
  • <NOTHING> -do not limit (Default value)
  • <DECIMAL> -Allows you to limit the results to only those with a Return Value greater than or equal to this value.
Limit by Max Bin Value
  • <NOTHING> -do not limit (Default value)
  • <DECIMAL> -Allows you to limit the results to only those with a Return Value less than or equal to this value.
Return Value
  • BID- the base rule returns the bid value for analysis
  • AUCTIONITEM-the base rule returns the auction item Unique Identifier for analysis