Expression Query

[simbai94]

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.

[swuehl]

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))

[simbai94]

Thank you Steven. Let me give this a go!

[simbai94]

Sorry. Thank you Stefan!