Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How do I filter out weeks with holidays or days off

Hi, I have a simple bar graph. For the Dimension, I have WeekYear and for the measure, I have sum(Sales).

My question is simple. How do I remove weeks with less than 5 days? I would essentially count the number of days where sales>0 and ignore the weeks where the count of days is <5.

Thanks.

0 Replies