how to write condition to get Weekly Hires

[#1]

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!

[sunny_talwar]

May be create a straight table with WeekYear_HireDate as Dimension and Count(DISTINCT EmployeeID) as the expression?

[ramasaisaksoft]

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