topic Re: Can you help me make a timechart that calculates work hours for employees? in Splunk Search

Can you help me make a timechart that calculates work hours for employees?

bogdan_nicolesc — Fri, 19 Oct 2018 15:05:47 GMT

Hi all,

I need to make a bunch of graphs for days, weeks and months per employee.

But first things first, i need for Monday to Sunday a timechart which counts for x hrs time.

Does anything i wrote make any sense?! 'Cus i'm bamboozling myself .... I don't know where to start ...

Thank you.

Re: Can you help me make a timechart that calculates work hours for employees?

adonio — Fri, 19 Oct 2018 15:50:12 GMT

yes, what you wrote makes sense, mainly about where to start.
maybe try ti start with looking at your data, and if possible, share with us so we can better help.
next i will recommend to articulate yourself the requirements for example: i read this: "..i need for Monday to Sunday timechart which counts for x hrs time." as how many hours an employee was sick last week. but you might mean to something completely different, like how many hours did an employee take lunch last week.
when you can articulate requirements and share data, we can better assist you, and better than than, you can assist yourself

Re: Can you help me make a timechart that calculates work hours for employees?

skoelpin — Fri, 19 Oct 2018 16:24:19 GMT

Why not have a single chart showing each employee?

Re: Can you help me make a timechart that calculates work hours for employees?

bogdan_nicolesc — Mon, 22 Oct 2018 08:37:25 GMT

That is something that we/i have to do ...

We need a list with all employees and then when i click on one of the names to send me to a dashboard showing more details about that person.

Re: Can you help me make a timechart that calculates work hours for employees?

bogdan_nicolesc — Mon, 22 Oct 2018 08:42:34 GMT

Ok, so i need 3 dashboards showing total work hrs from Monday to Friday (i suppose ... maybe i can include weekend too?!) then show work hrs for 3~4 weeks (1 month i suppose) and then show for 3~4 months ...

These 3 column charts are separate from each other.

Thx.

Re: Can you help me make a timechart that calculates work hours for employees?

skoelpin — Mon, 22 Oct 2018 14:31:57 GMT

Look into drilldowns

http://docs.splunk.com/Documentation/Splunk/7.2.0/Viz/DrilldownIntro

Re: Can you help me make a timechart that calculates work hours for employees?

bogdan_nicolesc — Tue, 29 Sep 2020 21:43:46 GMT

For now, i've made a timechart with worked hours (finally figured out what needed to be put there) on y axis and dates on x axis.

Next remains weeks and months, but for now i need to also see on x axis name of the day of the week. I've read some codes/articles about this but none works.

As i was asked before, no, i can't share dates from the indexed data.

But i can show you this: | pivot PerZiAngajat RootObject sum(RootObject.diff_time_in_out_min) AS "Ore Lucrate" SPLITROW RootObject.date_yyyymmdd AS Day SORT 7 RootObject.date_ddmmyyyy ROWSUMMARY 0 COLSUMMARY 0 SHOWOTHER 1

Also, it would be better to see last 7 days or something, because all i can see is (i think) first 7 days.

Thx