Filter Dashboard custom widget by Location (not just break)
Why? - I'm presenting a dashboard widget that breaks completed tasks by quarter and then by Location. But I only want to include certain Location values I use as multi-select category tags - in this case for feature sets of products.
Suggestion - Add Location to the Filter panel's list of fields with a way of selecting Location values. I realize it's not as simple as a select-all-that-apply list of values as for a picklist custom field. Selecting values would be more like when choosing a location to copy a Table view's column list from, only allow multiple Location values.
Current Workaround - There's no workaround to exclude all the non-tag Location values. I checked in the New Filters experience, too - no Location option so far.
Without this feature, all the Location values show (including a scrolling list at bottom of 30 rows - not shown) instead of the simpler split between about a half-dozen selected tags:
Hi John Spock Egleston,
have you tried to add location filters as a dashboard parameter?
Thanks, Pietro! I've tried adding Location as a parameter. Because that only accepts one Location value, I still can't break by several selected Location values.
In a separate dashboard, I'm varying Locations in each widget's data source, and can break those by an interesting custom field. It tells a different but related story - as a workaround. I can probably add the various Locations as the data source for one widget for a composite view, but not sure yet how the breaks will work.