Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have to develop a 7 day (only weekday) rolling chart for sales. how to filterout weekend dates on dimension ? any function to handle this or best possible way?
ex: my chart should display sales for below dates.
Mar 25
Mar 22
Mar 21
Mar 20
Mar 19
Mar 18
mar 15
Usually the best way is to create a field for workdays in the script. If oyu have field Date, for all days, it will be
if(weekday(Date)<5, Date) as WorkDay
Regards,
Michael
Usually the best way is to create a field for workdays in the script. If oyu have field Date, for all days, it will be
if(weekday(Date)<5, Date) as WorkDay
Regards,
Michael
See attached example
Instead of max(Date) you could use today() if you only want to calculate the last 7 workdays from today: sum({<Date={'>=$(=firstworkdate(today(),7))'}>}Sales)