1 2 3 Previous Next 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
        Muhammad Khan

        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

          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

            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
              khalid norat

              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

                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
                  Muhammad Khan

                  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

                    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

                      Hi

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

                       

                      Thanks

                      • 23. Re: Pie Chart with two Measures
                        khalid norat

                        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

                          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

                            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

                              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

                                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

                                  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

                                    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