double values

[soniasweety]

Hi all,

kaushik.solanki‌

youssefbelloum‌ omerben2016‌

is there any way to show both values and %  at a time on pie chart Qliskense?

anyone has some sample please share

[OmarBenSalem]

sure:

in u pie chart;

as dimension:

=YourDim&' : '& aggr(num(sum(YourMeasure)/sum(total{<YourDim>} YourMeasure),'#,##0.00%'),YourDim)

as a measure:

sum(YourMeasure)

Under aspect > presentation, show the values:

result (per aalogy):

[soniasweety]

thanks.

but in my case its not working  below am using  what is the issue here?

Dim: [In/Ex]

Meausre:count({<JDate={">=$(=vStartDate)<=$(=vEndDate)"},[JStatus]={'Joined'}>}[ID])

=[In/Ex]' : '& aggr(num(sum(count({<JDate={">=$(=vStartDate)<=$(=vEndDate)"},[JStatus]={'Joined'}>}[ID]))

/sum(total{<[In/Ex]>}

count({<JDate={">=$(=vStartDate)<=$(=vEndDate)"},

[JStatus]={'Join'}>}[ID])),'#,##0.00%'),[In/Ex])

[OmarBenSalem]

Your dim would be :

=[In/Ex]' : '&

aggr(num( (count({<JDate={">=$(=vStartDate)<=$(=vEndDate)"},[JStatus]={'Joined'}>}[ID])

/

count(total {<[In/Ex]=, JDate={">=$(=vStartDate)<=$(=vEndDate)"},[JStatus]={'Joined'}>}[ID])),'#,##0.00%'),[In/Ex])

[soniasweety]

showing as invalid dimension

and what could be my measure?  can I add sum(my meausre) ?

[OmarBenSalem · Accepted solution]

the

sum(YourMeasure) = count({<JDate={">=$(=vStartDate)<=$(=vEndDate)"},[JStatus]={'Joined'}>}[ID])

maybe it's a syntax thing: let's try again:

dimension:

=[In/Ex]&' : '& aggr(num(count({<JDate={">=$(=vStartDate)<=$(=vEndDate)"},[JStatus]={'Joined'}>}[ID])

/count( total {<[In/Ex]=,JDate={">=$(=vStartDate)<=$(=vEndDate)"},[JStatus]={'Joined'}>}[ID]),'#,##0.00%'),[In/Ex])

measure:

count({<JDate={">=$(=vStartDate)<=$(=vEndDate)"},[JStatus]={'Joined'}>}[ID])

[soniasweety]

yes its working thanks a lot 

but colour it  is showing grey only one colour . total pie. ?

I want two colurs

[OmarBenSalem]

under color, color by dimension and choose ur original dimension (not the modified one) but [In/Ex].

[soniasweety]

thanks  omerben2016‌

[OmarBenSalem]

it's omarbensalem‌