Department.strikerate

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

For example, if you have the sales show, the the strikerates are:

Sale #1	Sale #2	Sale #3
Product/Dept A	Product/Dept A	Product/Dept A
Product/Dept B		Product/Dept B
Product/Dept C

Product/Dept A = 3 distinct sales / 3 total sales = 100%
Product/Dept B = 2 distinct sales / 3 total sales = 67%
Product/Dept C = 1 distinct sale / 3 total sales = 33%
Product/Dept M = 0 distinct sales / 3 total sales = 0%

Syntax

 = Pinboard("department.strikerate", Department-Number, Location, Start Date, End Date)

Department-Number

Required. Identifies the department 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("department.strikerate", 4,2,"1 may 2015", "1-jun-2015")

Return the strikerate in the month of May 2015 for department #4 in store #2