[Resolved] Filter to Show Unique Values

[Author]

Posts

[laurieL]

I am trying to: Group View Results by Unique values.

I have a "City Events" Post Type with meta values for that cities' Country and would like to display a list of City Events sorted by Country, with the Country value displayed only on its' first occurrence. (ex:

Canada
-Toronto
-Winnipeg

Italy
-Milan
-Rome

USA
-Chicago
-Seattle

I feel like I need to use some nested views, but have not quite cracked the logic:

I have an outer-view to display all City Events, ordered by Country that in turn calls a sub-view to list the cities for that country.

I cannot figure out how to limit the outer view to unique values. Is it possible? Any direction will be greatly appreciated!

[Waqas Supporter Languages: English (English ) Timezone: Asia/Karachi (GMT+05:00)]

I will suggest to read following article, although it is around "How to group Views results by year and month" but it may help in your case too:

https://toolset.com/2013/10/how-to-group-views-results-by-year-and-month/

However, I will try improving the architecture. I suggest you create a custom Taxonomy for "country", register it to post type "City Events", then create a nested view:

1) parent view list all country
2) child view list all "City Events" under parent country

Here is a document about Views Inside Views – Display Nested Multidimensional Lists
https://toolset.com/documentation/user-guides/using-a-child-view-in-a-taxonomy-view-layout/

Hope it helps.

[laurieL]

I changed the data structure so cities belong to countries (as they should) and everything is swell now! thanks!