how to show percentages of only two years in pie chart

[bvssudhakar]

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

[bvssudhakar]

Hi franky_h79‌stalwar1‌mbaeyens‌

Can you guys please look for this and help me out

[tresesco · Accepted solution]

Like this?

If so, uncheck 'Relative' in expression tab and check 'Show in Percent %' in number tab.

[bvssudhakar]

Hi Tresesco,

Yeah Like this only, But I want to create for Financial year 2017 and Finacial Year 2018  (e.g.March-2017 to April 2018 like this way)

[tresesco]

So, your actual calendar is normal calendar (year starts with Jan), however, you want this pie representation to show the FY data, right? If so, you could use date in the set analysis instead like,

=count({<Recruiter={'Irfan Memon','Rajiv Ranjan','Aditi Saxena','Sneha Singh'},Date_Flag={'DeclineDate'},

LinkDate={">=$(=Date(MakeDate(2017,4,1))) <=$(=Date(MakeDate(2018,3,1)))"}>}CandidateID)

/

count({<Recruiter={'Irfan Memon','Rajiv Ranjan','Aditi Saxena','Sneha Singh'},Date_Flag={'offerdate'},

LinkDate={">=$(=Date(MakeDate(2017,4,1))) <=$(=Date(MakeDate(2018,3,1)))"}>}CandidateID)

Now, if you need to make it dynamic or selection-proof, you have to adjust the expression accordingly.

[bvssudhakar]

Can you please adjust the expression for selection and dynamic proof way

and

again i have doubt for this expression also: I want to show it for 2 year FY's. can you please modify for me

[bvssudhakar]

Can you please adjust the expression for selection and dynamic proof way

and

again i have doubt for this expression also: I want to show it for 2 year FY's. can you please modify for me... Means Current FY still going na so that how to modify