Calculating the sum for each condition in pie chart

[berryandcherry6]

I want to put a pie chart where it has to show count of lender_offer_id for particular client who has scored less than 80% , between 80%-90% and exactly 100%.

You could refer attached database file.Please help me on this.

[varshavig12]

Chart type:

Pie

Calculated dimension:

=if(completion_percentage<80,'less than 80',

if(completion_percentage=80 or completion_percentage<100 ,'80-99',

'100'))

expression:

count( lender_offer_id)

[berryandcherry6]

Hi varshavig12 ,

Thanks for your reply

I need to put condition for particular client _id  also ,where could i put that condition in above codde?