Skip to main content
Solved

Creation of secondary Dimension list automatically

  • August 25, 2025
  • 2 replies
  • 115 views
Chahat
Master Helper
Forum|alt.badge.img+14
  • If there is a dimension list called “Documents list” ,
  • there is a boolean metric A with dimensionality “Documents” list and “Team”
    It’s a boolean metric which tells the documents are relevant to which all team(s),
    if a document XYZ is marked checked for “Team 1” and “Team 2”, then in the top page filter while choosing either Team 1/ Team 2 , “document XYZ” row should show up

How to create another dimension list say “Detailed documents” dynamically

Best answer by farhan13

Hi ​@Chahat hope all is well.

To create a dynamic "Detailed documents" dimension that filters based on team selection, you'll need to use filtering. Instead of creating a new dimension, filter the existing "Documents list" dynamically:

  1. Create a filtered view on your board/table
  2. Add a filter condition: Metric A = TRUE
  3. Apply page-level filter for "Team"
  4. When users select "Team 1" or "Team 2" in the page filter, only documents where Metric A = TRUE for that team will display

The best approach is to use filtered views, which update automatically when the Boolean metric changes. This lets you show only the relevant documents for the selected team without creating a new dimension list.

For more information on these topics refer to our Community articles below:

 

Pigment currently doesn’t support automatically creating or populating dimension lists from metrics or other lists. 

Feel free to post this as an product suggestion in our Ideas portal: https://community.pigment.com/ideas

2 replies

F
Employee
Forum|alt.badge.img+4
  • farhan13Employee
  • Employee
  • Answer
  • August 26, 2025

Hi ​@Chahat hope all is well.

To create a dynamic "Detailed documents" dimension that filters based on team selection, you'll need to use filtering. Instead of creating a new dimension, filter the existing "Documents list" dynamically:

  1. Create a filtered view on your board/table
  2. Add a filter condition: Metric A = TRUE
  3. Apply page-level filter for "Team"
  4. When users select "Team 1" or "Team 2" in the page filter, only documents where Metric A = TRUE for that team will display

The best approach is to use filtered views, which update automatically when the Boolean metric changes. This lets you show only the relevant documents for the selected team without creating a new dimension list.

For more information on these topics refer to our Community articles below:

 

Pigment currently doesn’t support automatically creating or populating dimension lists from metrics or other lists. 

Feel free to post this as an product suggestion in our Ideas portal: https://community.pigment.com/ideas

Chahat
Chahat
Master Helper
Forum|alt.badge.img+14
  • ChahatMaster Helper
  • Author
  • Master Helper
  • August 26, 2025

Yes, I had tried this approach and it worked

Thank you, ​@farhan13 ! 

Ask your question here!

Terms & ConditionsCookie settingsAccessibility statement