Headcount trend report

Thu, 06 Jun 2013 08:58:55 GMT

Hello,

I have a list of employees with [start date] and [end date].

I must prepare a line trend report for each month in a year, showing trend...

So bascially I must know how many employees were working on every month's 1st day and then create a line report which will connect those data dots...

So employee was active on month's first when his start date <= 1/MM and his end date > 1/MM, or empty

The tricky part is that I must also divide this information by other dimensions - for example function or division.

So in one chart I must have separate trend lines for all functions for current year.

How should I create expressions to achieve this?

My biggest issue is with Month field I should use in chart, I do not know how to create a field in employee data for this...

BR,

Kuba

Re: Headcount trend report

swuehl — Thu, 06 Jun 2013 09:15:44 GMT

You could try using an intervalmatch in your load script, or create a link table. Henric posted about both suggestions recently: