Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have Hire Date and i have Date Extracted from my table. I need to know how many Hires i have in a week, as my data gets refreshed every week.
what should be the If condition statement for this. how to find out weekly hires from data.
for example.
Thanks!
May be create a straight table with WeekYear_HireDate as Dimension and Count(DISTINCT EmployeeID) as the expression?
Hi Srikant,
you need to create a field like this in Script week(DateId) as Week
=if(week=Max(week), count(Hires))
it will solve ur issue for Current week