PIE CHART

[#1]

HI ALl,

I have to show a pie chart by count of members and coount of customers

the pie chart should give me percentage og customer and percentage of members

but there should not be any dimensions in it .

I Have already ploted a pie chart writng in expression as

count( Customers)

count( members )

But this is showing me pie chartlike 100% customers , the percentage is not being showed for mebers

What do i do ? can someone help me on this

[PrashantSangle]

Try with gauge chart

Regards

[MK_QSL]

COUNT Of Customers and Members with respect to what?

Have you tried Count(Customer)/COUNT(ALL Customer)?

[danieloberbilli]

Something like that...please find qvw attached

[jagan · Accepted solution]

Hi,

Try like this

Calculated Dimension: ValueList('Customers', 'Members')

Expression : =If(ValueList('Customers', 'Members') = 'Customers', Count(Customers), Count(Members))

Regards,

Jagan.