Description -
In Analysis Workspace, users may want to define constant values (like a yearly sales goal or revenue-per-order threshold) and use them in multiple places, like multiple projects, segments, or calculated metrics. However, the only current way to achieve this is through calculated metrics, which come with a bunch of disadvantages:
- They can't be used in segments
- If they are used in other calculated metrics, they are copied instead of referenced. Therefore, changes to the original metric will not be reflected in other metrics where the original has been used
This makes this approach unmanageable for values that might change in the future, which can be especially true for sales goals.
Why is this feature important to you -
Avoid inconsistency in reporting and extreme maintenance overhead when working with goals or other, widely used metrics.
How would you like the feature to work -
In addition to the already available component types, introduce a "Constant" type of element. We should be able to create, edit, and delete them from within workspace, and also share them with users, groups, or the whole company. The interface for creating and editing them should be very simple and just allow us to input a number and a name. The constants would then show up in a list and be available in workspace and the editors for segments and calculated metrics. Any changes to the constant should then be reflected everywhere it has been used.
Current Behaviour -