Can I add a filter or somehow manage my Report by month?

[kennethtran]

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?

[adonio · Accepted solution]

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

[adonio]

how does your data looks like?

[kennethtran]

My current report of employees has all the first name, last name, work place, managers, ID, emails, and hire date, etc. if that helps.

[adonio]

what is the format of the hire data?

[kennethtran]

It is written like this 04/24/2019 for April 24th and so on.