Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Date | Availability | Status | Vendor | Tech | ID |
---|---|---|---|---|---|
1/01/2018 | 0.99 | B | Huawei | 2G | A0001 |
2/02/2018 | 0.98 | A | Samsung | 3G | A0002 |
25/01/2018 | 0.999 | B | Huawei | 3G | A0003 |
4/04/2018 | 0.97 | A | Huawei | 2G | A0004 |
7/04/2018 | 0.975 | A | Samsung | 2G | A0005 |
25/04/2018 | 0.99 | B | Samsung | 2G | A0006 |
Hie Guys. I would like to write an expression that will enable me to count the number of 'ID's by 'Tech' and 'Vendor' which satisfy the condition that Count (Status = 'A' ) => 14 per month.
Kindly Assist!!!
Thank you.
Seems like you want to group your results by Tech and Vendor, so create a chart with two dimensions, Tech and Vendor.
Then use as expression:
=Sum( Aggr( If(Count({<Status = {'A'}>} Status) >= 14, 1,0), Tech, Vendor, ID))
Thank you Steven. Let me give this a go!
Sorry. Thank you Stefan!