Skip to main content
  • 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

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

Yes, I had tried this approach and it worked

Thank you, ​@farhan13 ! 

Reply


Ask your question here!

Terms & ConditionsCookie settings