product.strikerate

Returns the strikerate for a single product. A strikerate is the number of sales that contain at least one item from the department as a percentage of all sales. See department.strikerate pinboard for deeper explanation.

Syntax

 = Pinboard("product.strikerate", Product-Number, Location, Start Date, End Date)

Product-Number

Required. Identifies the product to calculate

Location

Optional. Requests that strikerate for a single location is returned

Start Date

Optional. Specifies the beginning of the period to calculate strikerate over. If not supplied the server will substitute a suitable value, typically the last 365 days

End Date

Optional. Specifies the end of the period to calculate strikerate over. If not supplied the default is "today".

Example

 =Pinboard("product.strikerate", 6011,,"1 may 2015", "1-jun-2015")

Return the strikerate in the month of May 2015 for product 6011