Hello,
How can we take a minimum date in a grouping scenario. I tried using the
min function but it converts all dates to a fixed e Value.
rollup(
search(employee_position,
q="*:*",
qt="/export",
fl="EMPLOYEE_ID_s,POSITION_ID_s,HIRE_DATE_dt",
df="_text_",
sort="POSITION_ID_s asc, HIRE_DATE_dt asc"),
over="POSITION_ID_s",
count(HIRE_DATE_dt),
min(HIRE_DATE_dt))
==
"docs": [
{
"min(HIRE_DATE_dt)": 1.7976931348623157e+308,
"POSITION_ID_s": "017681N",
"count(HIRE_DATE_dt)": 1
},
{
"min(HIRE_DATE_dt)": 1.7976931348623157e+308,
"POSITION_ID_s": "017686N",
"count(HIRE_DATE_dt)": 2
},
