to get the count of Mondays for example you can simply use count({<[Day Name Field] = {'Monday'}>} [Day Name Field]) you can do the same for the rest of the days.
Hi I looked at the answer above, but I am having trouble applying this:
I then make the table thus: I don't know what is happening!
| =Monthname(AdmDate) | count(if(WeekDay(AdmDate) = 'Sat', 1)) | count({<[DayAdmDate] = {'Mon'}>} [AdmDate]) |
|---|
| Jul 2017 | 39 | 90 |
| Aug 2017 | 19 | 55 |
is the problem the week day and then the month????
Jo
| MonthAdm | =date(AdmDate, 'www dd/MM/yyyy') | num(WeekDay(AdmDate) +1 ) | (WeekDay(AdmDate) ) |
|---|
| Jul 2017 | Sat 01/07/2017 | 6 | Sat |
| Sun 02/07/2017 | 7 | Sun |
| Mon 03/07/2017 | 1 | Mon |
| Tue 04/07/2017 | 2 | Tue |
| Wed 05/07/2017 | 3 | Wed |
| Thu 06/07/2017 | 4 | Thu |
| Fri 07/07/2017 | 5 | Fri |
| Sat 08/07/2017 | 6 | Sat |
| Sun 09/07/2017 | 7 | Sun |
| Mon 10/07/2017 | 1 | Mon |
| Tue 11/07/2017 | 2 | Tue |
| Wed 12/07/2017 | 3 | Wed |
| Thu 13/07/2017 | 4 | Thu |
| Fri 14/07/2017 | 5 | Fri |
| Sat 15/07/2017 | 6 | Sat |
| Sun 16/07/2017 | 7 | Sun |
| Mon 17/07/2017 | 1 | Mon |
| Tue 18/07/2017 | 2 | Tue |
| Wed 19/07/2017 | 3 | Wed |
| Thu 20/07/2017 | 4 | Thu |
| Fri 21/07/2017 | 5 | Fri |
| Sat 22/07/2017 | 6 | Sat |
| Sun 23/07/2017 | 7 | Sun |
| Mon 24/07/2017 | 1 | Mon |
| Tue 25/07/2017 | 2 | Tue |
| Wed 26/07/2017 | 3 | Wed |
| Thu 27/07/2017 | 4 | Thu |
| Fri 28/07/2017 | 5 | Fri |
| Sat 29/07/2017 | 6 | Sat |
| Sun 30/07/2017 | 7 | Sun |
| Mon 31/07/2017 | 1 | Mon |
| Aug 2017 | Tue 01/08/2017 | 2 | Tue |
| Wed 02/08/2017 | 3 | Wed |
| Thu 03/08/2017 | 4 | Thu |
| Fri 04/08/2017 | 5 | Fri |
| Sat 05/08/2017 | 6 | Sat |
| Sun 06/08/2017 | 7 | Sun |
| Mon 07/08/2017 | 1 | Mon |
| Tue 08/08/2017 | 2 | Tue |
| Wed 09/08/2017 | 3 | Wed |
| Thu 10/08/2017 | 4 | Thu |
| Fri 11/08/2017 | 5 | Fri |
| Sat 12/08/2017 | 6 | Sat |
| Sun 13/08/2017 | 7 | Sun |
| Mon 14/08/2017 | 1 | Mon |
| Tue 15/08/2017 | 2 | Tue |
| Wed 16/08/2017 | 3 | Wed |
| Thu 17/08/2017 | 4 | Thu |
| Fri 18/08/2017 | 5 | Fri |
| Sat 19/08/2017 | 6 | Sat |
| Sun 20/08/2017 | 7 | Sun |
| Mon 21/08/2017 | 1 | Mon |
| Tue 22/08/2017 | 2 | Tue |
| Wed 23/08/2017 | 3 | Wed |
| Thu 24/08/2017 | 4 | Thu |
| Fri 25/08/2017 | 5 | Fri |
| Sat 26/08/2017 | 6 | Sat |
| Sun 27/08/2017 | 7 | Sun |
| Mon 28/08/2017 | 1 | Mon |
| Tue 29/08/2017 | 2 | Tue |
| Wed 30/08/2017 | 3 | Wed |
