Absolute value, Percentage & Fixed Value button Creation in board.

Hi ​@Spandan98, one solution could be to create a dimension “Input type” with the three options you want to provide, i.e. there would be three items in it: “Absolute Value”, “Fixed Value”, “Percentage”. If this dimension is part of your input metric, you can apply a filter in your view.

If you want this setting to apply to the whole view, you could create a variable for which “allow changes” is enabled, then add a filter to your view to filter for this variable so that a page selector is exposed through that. The user then can choose the input type they want to enter into. To show the numbers in correct format, you might need three additional metrics (single dimension “Input type”, type boolean), e.g. “CF Format Percentage”, “CF Format Number”, “CF Format Integer”, that returns true only for the according input type. Then apply conditional formats in your view, i.e. “when metric X TRUE, then format as percentage”, “when metric Y TRUE, then format as number” etc. One downside with this approach is you might end up with inputs in multiple input types. To resolve multiple inputs, you could either combine all of them, if this is desired, or have to apply some priorities to which input type should be taken in this case (easy to do via REMOVE FIRSTNONBLANK and dimension items being correctly ordered by priority in the dimension).

If you want to tie the input type selection to one or more other dimensions (e.g. by cost centre etc), you can create an input metric with whatever dimensionality you need with data type dimension → “Input type” (data type dimension instead of boolean, so that only one single type can be chosen per combination) and then create a boolean metric on top of it, that will give you the correct input type per combination. Then add this boolean metric to your view and apply a filter that takes this metric into account. You would then also need some conditional format, similar to what I described earlier.

Does one of these approaches help you in what you’re trying to achieve?

Hello, 

Thank your for your suggestions,

I actually want to create a way, such that if one person wants to enter data for a particular metric in percentage then all the other options cannot be accessed(such that they cannot enter absolute or fixed values for the particular metric). 

I want to keep it seamless and not create multiple metrics. Is it achievable or I have to create multiple metrics for creating such options.

Please kindly let me know. Thanks!