Vacation data against match dates

user007663

Hello,

 

I want to build in a card wherein I want to show aggregrate of vacantion hours taken by employees for a month. Against the same I also have to plot or show football match dates, to see if the vacation is taken around the match dates. Any idea to do this?

 

Thanks & Regards,

Bharti

jhl

Hi Bharti,

 

I would assume (without knowing anything more about this, it actually sounds interesting, I figure this would be insightful for world cups etc...) you will need your input data as something like this (dummy)

 

Date   Vacation Hours   Football Game

10/10/17   18   1

11/10/17   7    0

...

 

(third column could count football games, or just be a true/false or whatever you like (you can also just get something like this using a dataflow from two different datasets).

 

And then you can either graph, say, average vacation hours per day for a given month (where there is no football game) against average number of vacation hours taken per day for a given month where there was a football match.

 

You can do this by using a "grouped bar" chart or any of the line/bar combinations.

 

Then just create two beast modes

"Football days"

SUM(case when `Football Game`=1 then `Vacation Hours` end)

and

"Non-Football Days"

SUM(case when `Football Game`=0 then `Vacation Hours` end)

 

and plot those next to each other.

 

 

HTH