I want to count all review products in Magento 2 like :
There are 5 reviews 1 star
There are 3 reviews 2 star ....
Pls Help me, Thanks
Try the below solution:
Create and call the below code with product ID.
Don't forget to enable 1 rating option in admin.
public function getAllStart($pid) { $review = $this->_objectReview->getCollection() //\Magento\Review\Model\Review $reviewFactory (_objectReview) ->addFieldToFilter('main_table.status_id', 1) ->addEntityFilter('product', $pid) //$pid = > your current product ID ->addStoreFilter($this->_storeManager->getStore()->getId()) ->addFieldToSelect('review_id'); $review->getSelect()->columns('detail.detail_id')->joinInner( ['vote' => $review->getTable('rating_option_vote')], 'main_table.review_id = vote.review_id', array('review_value' => 'vote.value') ); $review->getSelect()->order('review_value DESC'); $review->getSelect()->columns('count(vote.vote_id) as total_vote')->group('review_value'); for ($i = 5; $i >= 1; $i--) { $arrRatings[$i]['value'] = 0; } foreach ($review as $_result) { $arrRatings[$_result['review_value']]['value'] = $_result['total_vote']; } return $arrRatings; }