Filtering Calculated Fields in Charts

BonganiButh — Wed, 09 Jun 2021 17:25:12 GMT

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. 🙂

topic Filtering Calculated Fields in Charts in App Development

Filtering Calculated Fields in Charts