Is there a way to create groups and then filter within those groups
My discovery table needs to contain some groups so I can filter by those. For example with countries the data set we use has them broken out, I will need to create a group for all the European countries. Then I want to add a filter that will display the US or/and Europe countries (multi-select drop down filter). I
How do I create groups and then filter by those?
You can use the Variable Lists options to achieve this. Effectively you are creating your groups or Lists, then have a Variable displayed as a drop down, to select which List to show in the grid.
This feature was introduced in 2018.04 and there is a short video tutorial on it you can find here https://community.pyramidanalytics.com/t/h4r0bf/pyramid-2018-04-released. It is the 12th video in the list.
Let me know if you need any further help on this.