How to create control with column names as a dropdown with datatype as decimal in the dataset
Please follow the below steps to achieve the use case to create control with column names as a dropdown with datatype as decimal in the dataset:
Please refer the below dataset and its datatype before moving to steps
Steps:
-
Create a parameter named as “columnnames” check the screenshot (parameter) with static value as “10/01/24 0:00”
-
Created a calculated field with the formula;
ifelse(${columnnames}= '10/01/24 0:00',{1/10/24 0:00},${columnnames}= '11/01/24 0:00',{1/11/24 0:00},${columnnames}= '12/01/24 0:00',{1/12/24 0:00},${columnnames}= '13/01/24 0:00',{1/13/24 0:00},NULL)
Here columnnames is the parameter name
-
Created a control named as “cn” please find the screenshoot(control) with specific values as name of the columns
-
Created a visual with calculated field as a column as shown in screenshoot (visual)
