
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!
- Tags:
- chart
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
PERFECT!!! Both ideas are excellent! Thank you Gary!!!!!!!!!!!!!!!!
