Forum Discussion

fernandoC's avatar
fernandoC
Helper V
5 years ago
Solved

Pivot fields to filter visual

Hi!   I'm trying to create a pie chart that counts the source of a candidate 'only' if it has been hired. To do this there's two steps in the process:   1- That the 'Offer Resolution' column is =...
Need Help
Show and Tell
  • vanessafvg's avatar
    vanessafvg
    5 years ago

    hi this is not the most elegant solution, i would probably try and merge them in power query but since i dont have access to the source file what i have done is created a new table called offer accepted, and filtered that only on accepted offers.  I then join that back to link main info on the destination id = source id (look in the relationship view how i have joined them) and then created a measure that does that join with the conditions.

     

    im sure there is a better way to do this but it works.

     

     

vanessafvg's avatar
vanessafvg
Community Champion
5 years ago

hi yes the file was accesible, not really 100% what you asking for, i dont know if this answers your question, or do you want ot demonstrate what you expect the answer to be?

 

 

fernandoC's avatar
fernandoC
Helper V
5 years ago

Hi vanessafvg ,

 

Thank you for your reply. 

I'm looking to have a pie chart that counts the 'Sources' only when the column 'Offer Resolution' is 'Accepted'. What is happening is that the Sources are only present in Issue Type [Candidates] and the Offer Resolution only on Issue Type [Offers]. I would like to have them both in the same row in order to filter by Offer resolution. 

 

Any further questions please let me know.

 

Best,

  • vanessafvg's avatar
    vanessafvg
    Community Champion
    5 years ago

    Hi again

     

    how do you know which candidate has accepted the the offer, what links the candidate row to the offer resolution row? in order ot join them up you need to know the relationship between them.  i have had  look at the ids but there are some duplications and you have quite a lot of columns.    Also which  is the table you using link main info?   

     

    so what i need from you is

    a) how do you know the candidate that an offer has been given to, what identifying information helps you to join these 2 pieces of data together is it an id? if so which id.

    b) which table are you referrig to from what i can see you are using the link main info.  

     

    please give more information about which tables need to be used and what is the join between issue types of candidate to offer.

    • fernandoC's avatar
      fernandoC
      Helper V
      5 years ago

      Hi vanessafvg ,

       

      Please find my comments on your questions:

       

      a) how do you know the candidate that an offer has been given to, what identifying information helps you to join these 2 pieces of data together is it an id? if so which id. Yes!, the table that contains the link information is 'Link Main Info' under the column 'LINKNAME' with the category OfferedBy-Offer for candidate and there's two ID's the Source ID and Destination ID in this case I think the ID of the offer should be under the Destination ID column. 

      b) which table are you referrig to from what i can see you are using the link main info.  Yes the table used is Link Main Info. 

       

      Any further questions please let me know.

       

      Best,

      • vanessafvg's avatar
        vanessafvg
        Community Champion
        5 years ago

        hi unfortunately i am about to go away so i dont have time to assist maybe amitchandak  wants to step in and help. 

         

        otherwise i can help next week.