
15. Re: Pie Chart with two Measures
Muhammad Khan Jun 22, 2016 7:16 AM (in response to khalid norat)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]).
Thanks

16. Re: Pie Chart with two Measures
khalid norat Jun 22, 2016 7:48 AM (in response to Muhammad Khan)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

17. Re: Pie Chart with two Measures
Muhammad Khan Jun 22, 2016 8:10 AM (in response to khalid norat)Hello Khalid
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 %
Thanks

% Hired new.twbx 23.1 MB


18. Re: Pie Chart with two Measures
khalid norat Jun 22, 2016 8:15 AM (in response to Muhammad Khan)what are the total numbers you are getting for hired without filters does it match the number in my previous post

19. Re: Pie Chart with two Measures
khalid norat Jun 22, 2016 8:16 AM (in response to khalid norat)1 of 1 people found this helpfulI am getting
hired = 8931 83.7%
Available = 1739 16.3%

20. Re: Pie Chart with two Measures
Muhammad Khan Jun 22, 2016 8:19 AM (in response to khalid norat)yes that is correct, i did on a calculator that why i got too many points

21. Re: Pie Chart with two Measures
khalid norat Jun 22, 2016 8:20 AM (in response to khalid norat)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

22. Re: Pie Chart with two Measures
Muhammad Khan Jun 22, 2016 8:24 AM (in response to khalid norat)Hi
The bar charts in the attached work book shows total, hired and remaining.
Thanks

% Hired new.twbx 23.1 MB


23. Re: Pie Chart with two Measures
khalid norat Jun 22, 2016 9:23 AM (in response to Muhammad Khan)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
total 43041
If each line is for an individual then I believe the counts you are doing are not correct.
Could you please confirm

24. Re: Pie Chart with two Measures
Muhammad Khan Jun 22, 2016 10:23 AM (in response to khalid norat)Hello
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 Employed
Yes Yes
No No
Yes No
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".
Thanks

25. Re: Pie Chart with two Measures
khalid norat Jun 23, 2016 2:58 AM (in response to Muhammad Khan)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
Released Employed
Yes Yes
Yes No
No Yes
No No
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

26. Re: Pie Chart with two Measures
Muhammad Khan Jun 23, 2016 8:11 AM (in response to khalid norat)Hello Khalid
You are right and you got the question so now what formula should be used to get these three measures
1) Available
2) Hired and
3) Remaining
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
Thanks
Muhammad

27. Re: Pie Chart with two Measures
khalid norat Jun 23, 2016 8:30 AM (in response to Muhammad Khan)What I am finding difficult to understand is your calculation for remaining.
I understand
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
then
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

28. Re: Pie Chart with two Measures
Muhammad Khan Jun 23, 2016 9:20 AM (in response to khalid norat)Hi Khalid
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.
Thanks

29. Re: Pie Chart with two Measures
khalid norat Jun 23, 2016 9:32 AM (in response to Muhammad Khan)I don't think you understand what I need you to confirm
There can only be 4 segments as below
Employed Released
Yes No
Yes Yes
No Yes
No No
Please can you simply name each of the 4 lines above in terms of what they mean according to your requirements