1 2 3 41 Replies Latest reply on May 14, 2018 11:32 AM by Kelly McGrady Go to original post
• ###### 15. Re: Pie Chart with two Measures

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

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

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

• ###### 18. Re: Pie Chart with two Measures

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

I am getting

hired = 8931   83.7%

Available = 1739  16.3%

1 of 1 people found this helpful
• ###### 20. Re: Pie Chart with two Measures

yes that is correct, i did on a calculator that why i got too many points

• ###### 21. Re: Pie Chart with two Measures

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

Hi

The bar charts in the attached work book shows total, hired and remaining.

Thanks

• ###### 23. Re: Pie Chart with two Measures

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.

• ###### 24. Re: Pie Chart with two Measures

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

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

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

• ###### 27. Re: Pie Chart with two Measures

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

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

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

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

1 2 3