I am trying to convert chart straight table to Pie chart.
I have used same dim/expressions for the pie chart.
But, the legend count values (1-10 days, 10-30 Days, > 30 days) not coming which is same used in chart straight table.
below is the dim/expressions
Dimensions
=If(vUserInput, if(IsNull(EMP_RELIEVE_DATE) AND [EMP_STATE]='$(vEmPlaces)', date(EMP_RESIGN_DATE),date(EMP_RELIEVE_DATE)), if(not IsNull(EMP_RELIEVE_DATE) AND EMP_RELIEVE_DATE <= floor(Today()) AND [EMP_STATE]='$(vEmPlaces)', EMP_RELIEVE_DATE))
Exp1 : "Relieving_Date" (LABEL TEXT)
=If(vUserInput, if(IsNull([EMP_RELIEVE_DATE]),Date(EMP_RESIGN_DATE+vUserInput),Date(EMP_RELIEVE_DATE)),if(not IsNull([EMP_RELIEVE_DATE]) AND EMP_RELIEVE_DATE <= floor(Today()) AND [EMP_STATE]='$(vEmPlaces)', EMP_RELIEVE_DATE))
Exp2 : 1-10 Days
if([Relieving_Date]>=vCalDate10 And [Relieving_Date]<=vToday AND [Relieving_Date] <= Today() AND [EMP_STATE]='$(vEmPlaces)',1,0)
Exp3: 10-30 Days
If([Relieving_Date]>=vCalDate30 And [Relieving_Date]<=vCalDate10 AND [Relieving_Date] <= Today() AND [EMP_STATE]='$(vEmPlaces)', 1,0)
Exp3: >30 Days
If([Relieving_Date]<=vCalDate30 AND [Relieving_Date] <= Today() AND [EMP_STATE]='$(vEmPlaces)', 1,0)
How to retrieve the count values and show the legend in pie chart.
