Good night, how are you?
Sorry to bother you, I need some help and I believe you will be able to help me.
I need to set up a measure in Quicksight, where it counts the amount of “business days”.
Since the rule for working days would be Monday to Friday and part-time on Saturday.
Monday to Friday = 5
Saturday = 0.5
Sunday = 0
Would you be able to help me?
Are you looking for this?
Hello @Max
I tried to use this formula, using parameters, but I can’t insert it in the rule to disregard Sunday and consider Saturday as 0.5, could you help me?
You can use extract instead.
ifelse(extract('WD',{date})=1,0,extract('WD',{date})=6,.5,1)
@GuiFox -
Did Max’s solution solve your issue? If so, would you please mark this as Solution. If not, please let us know what additional help you need.