Hi Guys,
I am trying to create a straight table with one dimension as 'Sales Person' and then I want 5 expression columns which should show the follow ups for next 5 days (working days only)
In my data model, I have a follow up date field against each order Id.
Currently I am using an expression like this..
=count(DISTINCT(if([Follow up Date] = Date(Today()), OrderId)))
=count(DISTINCT(if([Follow up Date] = Date(Today()+1), OrderId)))
=count(DISTINCT(if([Follow up Date] = Date(Today()+2), OrderId)))
=count(DISTINCT(if([Follow up Date] = Date(Today()+3), OrderId)))
=count(DISTINCT(if([Follow up Date] = Date(Today()+4), OrderId)))
And labels like this
=Weekday(Today())
=Weekday(Today()+1)
=Weekday(Today()+2)
=Weekday(Today()+3)
=Weekday(Today()+4)
But doing this also including Saturday and Sunday. How can I skip Weekend so if today is Tuesday then it will show Monday as the fifth day instead of Saturday!
