1) I have dimension named "Employed" with YES and NO data. YES are those who are employed but "No" also include some other information then not employed, so my "Hired" calculated measure is on the basis of this formula IIF([Employed] = 'yes',1,0).
2) I have another dimension named "Released" with YES and NO data, where YES means available for hiring and NO means not available for hiring so my "Available" calculated measure in on the basis of this formula IIF([Released] = 'yes',1,0).
3) After these calculation I made another calculated called remaining so this one is the difference between Employed and Released which is based on this formula SUM([Available]) - SUM([Hired]).
Total Employed = Yes is 8931 you are saying 266 where are you getting this 266 from.
Can you please create a sheet with this figure that showing so I can work out exactly how you are calculating this number
Thanks again, basically i filtered the data with terms so 266 was for a particular term. Now I removed filters and full data is shown and the percentages are changed to 84.342 and 15.65.
It means hired are 84.342% and Remaining are 15.65 %
what are the total numbers you are getting for hired without filters does it match the number in my previous post
1 of 1 people found this helpful
I am getting
hired = 8931 83.7%
Available = 1739 16.3%
yes that is correct, i did on a calculator that why i got too many points
Are these the numbers you are looking for if so then I can send across what I have if not please tell me what numbers you require and we can workout what the problem is
Im trying to understand this a little further.
I understand how you are getting these graphs
is each line of data relating to a single person?
if each line is a single person then we have 4 option
Released = Yes and Employed = Yes = 8850
Released = No and Employed = Yes = 81
Released = Yes and Employed = No = 1739
Released = No and Employed = No = 32371
If each line is for an individual then I believe the counts you are doing are not correct.
Could you please confirm
You are right it is a bit tricky, we will solve it with below example of two attributes. as i did all of my calculation from these two attributes
Released means those who are released to apply of a job or not. so if realses then we have to count him in calculating our percentage but if not released then we have nothing to do with him.
Employed means those who are employed by some employer
Now look the total measure value will be 3 but the percentage of hired and remaining will be 50 / 50 because one the candidate is not released to apply for a job that why we don't count him in calculating percentage of "hired" and "remaining".
Im sorry Muhammad I didn't quite get your explanation
Each Individual has 2 attributes Employed and Released I understand that
The options we have with these 2 are
Now for the 4 possibilities you have 3 groups that they fall into
Either they fall into hired Group
Either Remaining Group
or Not counted.
Is all of that correct.
If that is correct against each of the 4 groups can you please write , Hired , Remaining or not counted. that will make things a lot clearer
You are right and you got the question so now what formula should be used to get these three measures
2) Hired and
For Available I did IIF([Released] = 'yes',1,0)
For Hired I did IIF([Employed] = 'yes',1,0)
For Remaining i did SUM([Available]) - SUM([Hired])
Now I want to compare Hired vs Remaining
What I am finding difficult to understand is your calculation for remaining.
If Employed = Yes then Hired
If Released = Yes then Available
What is your definition for remaining
Anyone that is released and not currently employed
if that is the right definition then your calculation is incorrect as you have individuals that can fall into both categories
for example If
You have 1500 total individuals
500 are available + Not Emplyed
500 are Not Avaialabe + Emplyed
500 are available + Employed
hired would be 1000
available would be 1000
according to your calculation remaining would be 0
I think what your answer should be is 500
which is anyone that is available that is not hired
Please confirm this makes sense and is correct
The remaining is simply the difference between available and hired. Bur you are also right i have some candidates who are nor released but hired because the got job by their own means. it will be better if you can produce another calculated field which can show those who are not released but hired.
I don't think you understand what I need you to confirm
There can only be 4 segments as below
Please can you simply name each of the 4 lines above in terms of what they mean according to your requirements