how to limit view to just show each type one time? I have a content type what is news, the news has a field type that is List (text) to keep different types of news. for example I have Health, Sport, Economic and etc.

So now I am going to create a block and have each of these type in that as a hyperlink.

I can do it and I created a new view block but each news_type may showing more than one time according to published content. 

How to set the view (for block) to just show news_types and show them just one time?
You can achieve this by following the steps given below:


Enable aggregation under Advanced Accordion of the view
Add Nid field &amp; set aggregation type as Count Distinct
Exclude Nid field from display
Add news type field &amp; set Aggregation type as Group results together, in Group Column select Value option from dropdown
Remove Publishing Date from sort criteria


Please check attached screenshot for reference



and for more information you can check this question