Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Ruthie09
Contributor III

How to chart business days only

I'm sure this is completely simple but here goes:  How do I chart only business days?

Right now, my expression is   =Date([IncCreated.autoCalendar.Date],'MM/DD/YY')  but I do not want to include weekends.  How do I do that?

Thanks!

Labels (3)
1 Solution

Accepted Solutions
GaryGiles
Specialist

With your expression, you could use:

=Date(if(Match(WeekDay([IncCreated.autoCalendar.Date]),'Mon','Tue','Wed','Thu','Fri')>0,[IncCreated.autoCalendar.Date]),'MM/DD/YY')

But it would more useful if you created a flag in your load script.  You would use the similar if statement logic in your load script.

 

View solution in original post

2 Replies
GaryGiles
Specialist

With your expression, you could use:

=Date(if(Match(WeekDay([IncCreated.autoCalendar.Date]),'Mon','Tue','Wed','Thu','Fri')>0,[IncCreated.autoCalendar.Date]),'MM/DD/YY')

But it would more useful if you created a flag in your load script.  You would use the similar if statement logic in your load script.

 

Ruthie09
Contributor III
Author

PERFECT!!!  Both ideas are excellent!  Thank you Gary!!!!!!!!!!!!!!!!