Skip to main content
Solved

How to exclude inactive values in a dimension in Page dropdown

  • November 21, 2024
  • 2 replies
  • 121 views

Neo
Author
Forum|alt.badge.img+3

Hi Community,

How can we exclude invalid values in a dimension from appearing in the Page Selector in Pigment? For example, we have some inactive project codes and cost centers that we’d like to remove from all dropdowns, but they still show up.

I believe there’s an option to manually edit the Page Selector to exclude those codes, but that would require updating it on every board and repeating the process whenever new codes are marked inactive.

Is there a cleaner or more efficient way to handle this?

 

 

Thanks,
Neo

Best answer by oliverlee

Hi ​@Neo , you can create a boolean metric and then use this as a dynamic source for an item variable. This variable then can be used to limit the “available items” for page selectors. You can read more here:

Is this what you’re looking for?

 

2 replies

oliverlee
Master Helper
Forum|alt.badge.img+12
  • Master Helper
  • Answer
  • November 21, 2024

Hi ​@Neo , you can create a boolean metric and then use this as a dynamic source for an item variable. This variable then can be used to limit the “available items” for page selectors. You can read more here:

Is this what you’re looking for?

 


Neo
Author
Forum|alt.badge.img+3
  • Author
  • Author
  • November 22, 2024

Thanks ​@oliverlee yes it works! I totally missed the ‘Available Items’ box in page selectors, been using Item Variables but just for the ‘Default Items’ box. Thanks so much!