Simulate IN clause in Mysql for Elastc search query?

Hi,

I am trying to implement graph in Elastic search in Table visual, which I have implemented in MySql. How can I simulate similar query in Elastic search.
MySql Query as follows:

Select
date_format(created_ts,’%b-%y’) as Month,
sum(prod_type IN (‘A’, ‘B’, ‘C’)) as ‘Type Received’,
sum(status IN (‘Failed’)) as ‘Type Rejected’
from
Type
where
$__timeFilter(created_ts) and status IS NOT NULL and prod_type IN (‘A’, ‘B’, ‘C’)
Group by
date_format(created_ts,’%b-%y’);