I am having trouble adding a specific filter to a dashboard. While on the dashboard edit page, when I select ‘Other Categories’ from the ‘Add a Filter’ dropdown button, a new select box appears on each card in the dashboard. All cards reference the same table. When I click the select box on the cards, I am given the option to select one of only eight fields on the table. The table has 31 fields. The field I would like to filter by is not available for selection.
How do I make a table field available for selection when creating a dashboard filter?