Hi,
I have a report that shows the number of hours worked for each employee.
Can I add a cumulative line, to show the cumulative for all employees?
The code I am using:
index=snow dv_state="Clos*"
| dedup number
| rex field=dv_u_total_time_spent "(?<DAYS>\d+)\s*Day"
| rex field=dv_u_total_time_spent "(?<HOURS>\d+)\s*Hour"
| rex field=dv_u_total_time_spent "(?<MINS>\d+)\s*Minute"
| eval DAYS = if((isnull(DAYS)), 0, tonumber(DAYS))
| eval HOURS = if((isnull(HOURS)), 0, tonumber(HOURS))
| eval MINS = if((isnull(MINS)), 0, tonumber(MINS))
| eval numberOfHours = round(((DAYS*8) + HOURS + (MINS/60)),0)
| chart sum(numberOfHours) AS "Number Of Hours" by dv_assigned_to
| sort -"Number Of Hours"
This is the result now:
I need a line that starts from the left side (ddaniel) in 400, and than moves to 750 (slavag) and so on.
Its not by time, so is this possible to add that cumulative line?
Thanks
try this!
<cumulative>
index=snow dv_state="Clos*"
| dedup number
| rex field=dv_u_total_time_spent "(?<DAYS>\d+)\s*Day"
| rex field=dv_u_total_time_spent "(?<HOURS>\d+)\s*Hour"
| rex field=dv_u_total_time_spent "(?<MINS>\d+)\s*Minute"
| eval DAYS = if((isnull(DAYS)), 0, tonumber(DAYS))
| eval HOURS = if((isnull(HOURS)), 0, tonumber(HOURS))
| eval MINS = if((isnull(MINS)), 0, tonumber(MINS))
| eval numberOfHours = round(((DAYS*8) + HOURS + (MINS/60)),0)
| chart sum(numberOfHours) AS "Number Of Hours" by dv_assigned_to
| sort -"Number Of Hours"
| accum "Number Of Hours" as cumulative
<total>
|addcoltotals labelfield=dv_assigned_to label=TOTAL
try this!
<cumulative>
index=snow dv_state="Clos*"
| dedup number
| rex field=dv_u_total_time_spent "(?<DAYS>\d+)\s*Day"
| rex field=dv_u_total_time_spent "(?<HOURS>\d+)\s*Hour"
| rex field=dv_u_total_time_spent "(?<MINS>\d+)\s*Minute"
| eval DAYS = if((isnull(DAYS)), 0, tonumber(DAYS))
| eval HOURS = if((isnull(HOURS)), 0, tonumber(HOURS))
| eval MINS = if((isnull(MINS)), 0, tonumber(MINS))
| eval numberOfHours = round(((DAYS*8) + HOURS + (MINS/60)),0)
| chart sum(numberOfHours) AS "Number Of Hours" by dv_assigned_to
| sort -"Number Of Hours"
| accum "Number Of Hours" as cumulative
<total>
|addcoltotals labelfield=dv_assigned_to label=TOTAL
the accum line was what I needed.
Thanks a lot!