I'm trying to do some math with the values calculated in the addtotals command and put them back into the same line but I can't seem to figure out how to do that. | eval daysEmployed = round((end - HireDate)/86400,0) | eval daysCanWork = if(HireDate <= start, numWorkDay, round((daysEmployed/7)*5,0)) | eval posibleHours=(daysCanWork-numHolidays) * 8 | eval totWorked=Billable+NonBillable | eval perBill=Billable/posibleHours | eval perNonBill=NonBillable/posibleHours | eval perWorked=totWorked / posibleHours | eval Billable=round(Billable,2) | eval NonBillable=round(NonBillable,2) | eval totWorked=round(totWorked,2) | eval perBill=round(perBill,2)*100 | eval perNonBill=round(perNonBill,2)*100 | eval perWorked=round(perWorked,2)*100 | addtotals col=true labelfield=Employee Label="Totals" posibleHours Billable NonBillable totWorked | eval perWorked=perWorked + "%" | eval perBill=perBill + "%" | eval perNonBill=perNonBill + "%" | sort -perBill | eval HireDate=strftime(HireDate,"%m/%d/%Y") | rename "Billing Class" as "Job Title", posibleHours as "Possible Hrs Worked", Billable as "Billable Time", NonBillable as "Non Billable time", totWorked as "Total Hrs Worked", perBill as "% Billable Time Worked", perNonBill as "% Non Billable Time Worked", perWorked as "Total % of time Worked", HireDate as "Date Hired" | fields Employee, "Job Title", "Date Hired", "Possible Hrs Worked", "Billable Time", "Non Billable time", "Total Hrs Worked", "% Billable Time Worked", "% Non Billable Time Worked", "Total % of time Worked" I'd like to do the following: Billable / totworked = perBill NonBillable / totWorked = perNonBill possibleHours / totWorked = perWorked If I just add the perBill,perNonBill,perWorked I just get the sums of those columns which is not what I'm trying to acomplish. ... View more

I have a field with a date in the format of %m/$d/%Y. I'm trying to use the date picker in the dashboard to only search for entries that are between the selected field. However I keep getting the error: Error in 'eval' command: The expression is malformed. An unexpected character is reached at '@y,"%m/%d/%Y")'. <form> <label>NS-Job-Month-Employee</label> <fieldset autoRun="true" submitButton="false"> <input type="time" token="selTime" searchWhenChanged="true"> <label></label> <default> <earliest>0</earliest> <latest></latest> </default> </input> </fieldset> <row> <panel> <title>NS-Job-Month-Employee</title> <table> <search> <query>|inputlookup NetHoursFile | eval DayofMth=strptime(DayofMth,"%m/%d/%Y") | eval stTime=strptime($selTime.earliest$,"%m/%d/%Y") | eval edTime=strptime($selTime.latest$,"%m/%d/%Y") | where DayofMth > stTime AND DayofMth < edTime | rename Non-Billable as NonBillable | eval totalHrs=Billable+NonBillable When I do a regular search the below works, but I cant figure out how to make the date picker do the same thing. |inputlookup NetHoursFile | where DayofMth > "1/1/17" AND DayofMth < "3/1/17" | rename Non-Billable as NonBillable | eval totalHrs=Billable+NonBillable ... View more