Forum Discussion

AhmedT001's avatar
AhmedT001
Frequent Visitor
1 year ago
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...
Need Help
  • AhmedT001's avatar
    AhmedT001
    1 year ago

    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 :). 

AhmedT001's avatar
AhmedT001
Frequent Visitor
1 year ago

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 :).