Restrict by Day of Week

Some pinboards are able to select a subset of data based on the day of the week. This means you can use date selectors to select a large range and the day of week restriction to select a subset. For example the month of January 2023 is shown. If you enter a date range of "1-jan-2023 to 1-feb-2023 and dayofweek=tue" then only values from the five tuesdays will be used.

Sun	Mon	Tue	Wed	Thur	Fri	Sat
1	2	3	4	5	6	7
8	9	10	11	12	13	14
15	16	17	18	19	20	21
22	23	24	25	26	27	28
29	30	31

The dayofweek takes a single parameter giving the day, you can enter any of the following

• The english 3 letter day abbreviation, mon, tue, wed, thu, fri, sat, sun.
• The full english description, monday, tuesday, wednesday, thursday, friday, saturday, sunday
• The single digit numeric day number, Sunday=0, Monday=1, Tuesday=2, Wednesday=3, Thursday=4, Friday=5, Saturday=6

=Pinboard("product.sales.count.period",20,"1-jan-2022","1-jan-2023",,,"dayofweek=tue")
or
=Pinboard($O$1,$B$1,$D$1,$F$1,,,CONCAT("dayofweek=",$A6))

Available on

• product.sales.count.period
• product.sales.revenue.period
• product.sales.linecount.period
• product.sales.revenue.notax.period
• product.sales.cost.period
• department.sales.count.period
• department.sales.revenue.period
• department.sales.linecount.period
• department.sales.revenue.notax.period
• sales.count.period
• sales.rawrevenue.total
• sales.rawrevenue.notax
• sales.rawrevenue.tax1
• sales.count.layby
• sales.count.parked

Worked Examples

Download .XLSX file Uses dayofweek restriction and also timeofday restriction to breakdown product/department sales by day and/or time
Download .XLSX file Uses dayofweek restriction on total sales