Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Today's date: LastWorkDate(today(),1)
LastWorkDate(today(),2)
LastWorkDate(today(),3)
LastWorkDate(today(),4)
LastWorkDate(today(),5)
LastWorkDate(today(),6)
Try
lastworkdate()
Today's date: LastWorkDate(today(),1)
LastWorkDate(today(),2)
LastWorkDate(today(),3)
LastWorkDate(today(),4)
LastWorkDate(today(),5)
LastWorkDate(today(),6)
Thanks mate got what I wanted