Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to obtain a percentage for a Bar Chart, with the dimension of Monthly results
The percentage is obtain from the number of resignations divided into the total employees of a company.
Resignations and Employees are two different tables, and both are organized by month.
How can I obtain the percentage if I used the month from Resignations as dimension gives one result if I used the month from Employees gives me another result.
Any suggestion?
Hi Andres,
If your two tables are associated on a month field then an expression like
count(EmployeeID)/count(ResignationID)
should work.
It would help if you posted some sample data so you could be given the expression using actual field names. Also there may be some issues that complicate matters that are not apparent from the brief outline you've given.
Kind regards
Andrew
Hi Andrew,
I use the following expression:
count({$<[TO_Employee/CW_Type]={"Regular"},TO_RATE_1_or_2={"Yes"},[TO_Voluntary/Involuntary_Terminations]={"Voluntary"}>}TO_Employee_ID)/
count({$<HC_Employee\CW_Type={"Regular"},HC_RATE_1_or_2={"Yes"}>}HC_Employee_ID)
Where the first statement is related to the resignations and second statement is related to employee data.
I think the issue I am experiencing is related to the Dimension
Cause I am using the month from Resignation TO_Month and not the month from Employee data.
Thanks,