How do I edit my search to only display results based on these conditions?

[manhuang]

index=app sourcetype=epcpromotionsevent | stats count as num  by eventName,hotelId

The search above will display count, eventName, and hotelId.
I only want to display results based on these conditions:
1.when count is 1, and more than 2 row data record, then display.
2.when count is more than 1, display.
3.others, no display.

[sundareshr · Accepted solution]

See if this works for you

index=app sourcetype=epcpromotionsevent | stats count as num  by eventName, hotelId | stats values(eventName) as eventName values(hotelId) as hotelId count by num | where count > 1 OR num>1

[jmallorquin]

index=app sourcetype=epcpromotionsevent | stats count as num by eventName,hotelId | where count > 1

[manhuang]

1.when count is 1, and more than 2 row data record, then display.

not just count bigger than 1 are displayed,it needs two data records whose count is bigger than 1.
If only one row data record which count is 1, I dont want to display.

[jmallorquin]

index=app sourcetype=epcpromotionsevent | stats count as num dc(eventName) as dc_e dc(hotelId) as dc_h by eventName,hotelId |eval row=dc_e+dc_h| where count > 1 AND row>2