topic suppress weekends on a report in Dashboards & Analytics Discussions

suppress weekends on a report

MT10 — Mon, 18 Mar 2024 08:29:12 GMT

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

Re: suppress weekends on a report

RADSr — Mon, 18 Mar 2024 18:17:20 GMT

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.

Re: suppress weekends on a report

mhornak — Wed, 20 Mar 2024 13:12:53 GMT

You can just use formula below in individual filter

Re: suppress weekends on a report

MT10 — Wed, 20 Mar 2024 13:22:55 GMT

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?

Re: suppress weekends on a report

RADSr — Wed, 20 Mar 2024 13:26:35 GMT

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! )

Re: suppress weekends on a report

mhornak — Wed, 20 Mar 2024 13:27:36 GMT

Yes, a week starts on Sunday and ends on Saturday.