Using Set Analysis to calculate Indicators

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Dear colleagues,

I have a table in which I have to do extract three KPIs:

ID	Date_Received	Type ID	Number_Products_Received	Number_Products_Demanded
1	01/01/2017	1	30	75
1	15/01/2017	1	45	75
2	16/01/2017	1	20	40
2	24/01/2017	1	20	40
3	15/02/2017	2	10	10

For indicator #1, I need to calculate the number of different IDs, which type is not 2;
For indicator #2, I need to calculate the number of products received per ID (it is important to say that there can be other field that can duplicate the values above)
For indicator #3, I need to calculate the number of products demanded per ID, which type is not 2 (please check that the field of number of products demanded replicates according to the received date - and there can be other fields which can duplicate the value as well)

Can anyone help me with this?

Thank you in advance!

Re: Using Set Analysis to calculate Indicators

sunny_talwar — Mon, 28 Aug 2017 15:39:41 GMT

May be these

1) Count(DISTINCT {<[Type ID] -= {2}>} ID)

2) Sum(Aggr(Sum(DISTINCT Number_Products_Received), ID, Date_Received))

3) Sum({<[Type ID] -= {2}>} Aggr(Sum({<[Type ID] -= {2}>} DISTINCT Number_Products_Demanded), ID))