Filtering Calculated Fields in Charts

[BonganiButh]

Hello Everyone. 

Please can you assist with the below. 

I have created a calculated field(Using an IF statement that essential compares two expressions) as seen in the screenshot below. What I require is 

1.  show only the results where = 1 ( As the calculated field has 0s/1s)

2. Selecting the top 5 results from the 1s.

Expression Used :  

IF(Aggr(COUNT({<[demand.bpart_gcl_id] = {'Labor'} ,
[demand.bpart_id] = {'PRIMARY ASSIGN'} ,
order_type_id = {'repair_order'},[service_call.rcode_id] =- {'Z31'}, [service_call_env.resolve_date_time.autoCalendar.MonthsAgo] = {0} >} order_id),[service_call_env.sa_person_id]) >=
[productivity_target.prod_target] * (Day(today())),1,0)

I have tried using  variables,set analysis and the 'Show Column If' feature but no luck as yet. I am not sure if this can be done in the charts or is it something I need to do in the data load editor?

Your assistance will be highly appreciated.

Thanks in advance. 🙂