suppress weekends on a report

[MT10]

Hi,

Let me know if there a way to define weekend days and suppress the same in a report for us to eliminate less productive days.

rgds

MT

[RADSr]

I'm always a proponent of having a calendar dimension modeled into your schema, which makes identifying weekend days easy. 

But absent that you can use either of the two "weekday" functions built into Incorta - Online Store dashboard w/ filter v non-filter attached.

[mhornak · Accepted solution]

You can just use formula below in individual filter

[MT10]

Hi, 

Thanks for the help. Need to know the whether number stands for week days.. right..

1-Sunday and 7-for Saturday.. is my understanding correct?

[RADSr]

You are correct - I'll be candid and tell you whenever I do something like that I do a quick check to make sure I'm remembering correctly.    Just run a report w/ date filters for the a week and add this function to it.    Quick, easy check.

It is also a good reminder to check w/ the business if that's how *they* define day numbers ( e.g. their fiscal week may start on Saturday instead of Sunday -- another argument for using a date dimension!  )