I’m looking for a way to make a Period choice based on the Work Days of a calendar for use in a dashboard. My company typically does not have sales on Saturdays or Sundays so using Yesterday for a dashboard period ends up showing no transactions when you review dashboards on Mondays. Is there a way to set up a period where it ignores non-work days such as weekends or holidays?
Hi Victor, what you’re asking for can be achieved by creating a new period type. You can create a file which would need to cover all the data in history, as well as far enough forward that future data will be included.
Using the following link,
You can see the format of the file that you would need to create, essentially 4 columns;
Name - This needs to be unique, we usually go for something such as ‘Mon - WK50 - 2018’ (if its a daily period)
Start Date - the start of the date range
End Date - the end of the date range
Year - The year the range is in
Using the above you can create a file for each day, Monday to Friday, but where Friday has a start date that starts on the Friday, but ends on the Sunday of each week. This way you will only ever have Monday to Friday in your date range, but should any sale ever get recorded on the weekend it would just fall into the Friday definition. This also means that when this period is then used in dashboards, if set to be offset, the previous 'period 'on a Monday would always then be Friday.
Does this help? This will need reflected in the summarisation of the build, so may need some input from a Phocas perspective to complete the work.
Hi Lee, thank you for the input. I understand what you’re saying.
Is there a way for Phocas to put in a check box when setting up a custom period that if checked, would not include non-working days as long as they were set up that way on your calendar?