6 Replies Latest reply: Sep 14, 2018 8:32 AM by Sudhakar Battula RSS

    how to show percentages of only two years in pie chart

    Sudhakar Battula

      Hi Experts,

       

      I have Different Date columns and i have created master calendar linked with those columns and i have created charts also those all are correct but now i got one more requirement which it is:

      I want to create pie chart and show the the percentage of only FY:2017 and FY:2018

      For that I wrote the Expression like this:

       

      =count({<Recruiter={'Irfan Memon','Rajiv Ranjan','Aditi Saxena','Sneha Singh'},Date_Flag={'DeclineDate'}, Year ={2017,2018}>}CandidateID)

      /

      count({<Recruiter={'Irfan Memon','Rajiv Ranjan','Aditi Saxena','Sneha Singh'},Date_Flag={'offerdate'}, Year={2017,2018}>}CandidateID)

       

      But i want it for FY:2017 and FY:2018

       

      Can you guys please suggest me how to achieve this. For your reference here i am attaching my qvw also. Please check it and give your valuable suggestions

       

      Note: I want to show only those two years percentage (e.g. if 2017 Percentage is :16, and 2018's is 30% like this)

       

      Thank you in advance