cancel
Showing results for 
Search instead for 
Did you mean: 

suppress weekends on a report

MT10
Ranger

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

5 REPLIES 5

RADSr
Captain
Captain

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.

RADSr_0-1710774516089.pngRADSr_1-1710774529523.png

 

-- IncortaOne@PMsquare.com --

mhornak
Ranger

You can just use formula below in individual filter

mhornak_0-1710940339243.png

 

 

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?

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

-- IncortaOne@PMsquare.com --