Forum Discussion
Solved
Ignore Weekend in Forecast
Hi, I've created a Line Chart with a Forecast using some data that is pulled out directly from our IBM dB2 Database. The image below is a snippet of the line chart, with sensitive data blocked ou...
I managed to figure it out by doing lots of reading/youtube/googling the fix was as follows.
1) Go to Transform Data.
2) In the Transcation Table, click on Add Column, then Custom Column
3) Give it a name, say Weekend for example.
4) In the Custom Column Formula section, input the following (without the quotes):
"if Date.DayOfWeek([INVOICE_DATE], Day.Monday) > 4
then
"Weekend"
else
"Weekday""5) Click Ok
6) Click Close&Apply
7) Add new Weekend field as a Filter on this page
😎Select Weekday
9) Problem solved :).
