Don't want to have to rely on data tables due to performance, but don't want users to be able to see every single field by expanding the row in the saved search on their dashboard. Any way around this?
If you are using "top hits" in aggregation based table vis (or "last value" in Lens) instead of "terms" (except for the first level splitting by id or something similar), the performance should be much better.
Can't use top hits. Purpose of the data table/saved search is to show position data for organization after user has filtered by department/location etc on dashboard. Data table can't handle someone who has security to see the entire org, but saved search can.