Number of employees month by month

[#1]

Hi Everyone,

I’m trying to make a human ressources dashboard. I am having issues doing a chart which represents the number of employees month by month.

Here’s a sample of my data :

Name	Date of employment	Date of exit
M. X	01/01/2016	-
Mrs. C	05/06/2014	31/10/2016
M. Y	03/09/2011	-

How can I do that ?

I thought about that kind of chart :

  Thanks in advance,

[its_anandrjs]

Use this dimension and expression

Dim:- Month

Expre:- Count(Name)

Regards

Anand

[Anonymous · Accepted solution]

Hi Sarah,

Please find attached the qvw. I have used interval match concept.

Hope this helps you.

[#4]

Thank you  very much !

Regards,

Sarah

[Anonymous]

Most Welcome...