Hello Pigment Community,
I’m looking for a way to create, delete, and select hierarchies directly from a board while allowing users to input values at specific levels.
Context:
We have multiple hierarchical dimensions:
-
Accounts (2 Levels)
- L1: Account Groups
- L2: Accounts
-
Geography (3 Levels, Parent of Accounts)
- L1: Region
- L2: Country
- L3: Area
-
Organization (2 Levels, Parent of Geography)
- L1: Organization_1
- L2: Organization_1.1
Use Case:
Users have revenue data and he wants to input data at this level:
- L1: Organization_1
- L2: Country
- L2: Accounts
I want to provide an interactive board where users can:
✅ Select the Organization Level, Geography Level, and Account Level for data input.
✅ Enter data at the chosen levels, ensuring calculations use only the selected hierarchies.
✅ Add new parallel hierarchies (e.g., Industry Level as a child of Organization) dynamically from the board.
Question:
How can I set this up in Pigment to allow users to manage hierarchies and input data flexibly?
Would love to hear any best practices or recommended approaches!
Thanks in advance.