I have a Population extract of all employees but want to create a report or only extract the ones that were hired in a certain month e.g. getting a report of all employees hired during the month of March. Can I input a filter or something on a report?
try something like this:
... search that creates your report ...
| eval month_year_of_hire = strftime(strptime(hire_date,"%m/%d/%Y"),"%m-%Y")
| eval full_name = first_name." ".last_name
| stats values(full_name) as employees by month_year_of_hire
| where month_year_of_hire = "Whatever you need here"
please note that you will probably need to modify the fields name i chose randomly to match your field names
try something like this:
... search that creates your report ...
| eval month_year_of_hire = strftime(strptime(hire_date,"%m/%d/%Y"),"%m-%Y")
| eval full_name = first_name." ".last_name
| stats values(full_name) as employees by month_year_of_hire
| where month_year_of_hire = "Whatever you need here"
please note that you will probably need to modify the fields name i chose randomly to match your field names
how does your data looks like?
My current report of employees has all the first name, last name, work place, managers, ID, emails, and hire date, etc. if that helps.
what is the format of the hire data?
It is written like this 04/24/2019 for April 24th and so on.