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

[bogdan_nicolesc]

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.

[bogdan_nicolesc]

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

[skoelpin]

Why not have a single chart showing each employee?

[bogdan_nicolesc]

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.

[skoelpin]

Look into drilldowns

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

[adonio]

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

[bogdan_nicolesc]

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.