Forum Discussion
Solved
HR COUNT
HI ALL,
I need a simple chart to show the total count of sales staff per month as per below table
a- active; in - inactive
so for June - total active is 10, inactive is 2 - in a simple matrix or column chart.
Please help how to do this
i think you are supposed to have an employeeid or name column.
select that column and unpivot other columns in PQ
then create a dim table.
pls see the attachemnt below
7 Replies
I saw more than 10 As and 1 IN in the first column. Why the total active is 10 and inactive is 2?
could you pls elaborate this?
What's more , could you pls paste the sample data here(not the screenshot)?
active is who are still working, inactive - staff who left
Jun-23 Jul-23 Aug-23 Sep-23 Oct-23 Nov-23 Dec-23 Jan-24 Feb-24 Mar-24 Apr-24 May-24 Jun-24 A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A IN IN IN IN IN IN IN IN A A A A A A A A A A A A A A A A A A same question, how to get 10 for active and 2 for inactive in Jun?
