How to create dashboard parameters using JSON data?
Introduction
In Bold BI, dashboard parameters can be a powerful tool to create interactive and dynamic dashboards. Parameters allow you to control the data that is displayed on your dashboard based on user input or predefined criteria. JSON data can be used to define these parameters, providing a flexible and structured way to control your dashboard’s content.
Steps to Create Dashboard Parameters Using JSON Data
1. Accessing the Parameter Settings
To begin, navigate to the dashboard design view within Bold BI. From there, you can access the parameter settings by selecting the ‘Parameters’ option.
2. Adding a New Parameter
In the parameters settings, you can add a new parameter by clicking on the ‘Add’ button, where you can define the details of your new parameter.
3. Inputting JSON Data
There are multiple ways to input JSON data for your parameter:
a. From a Data Source
If you have a data source that contains JSON data, you can link it to your parameter. Choose the appropriate data source from the list and select the field that contains your JSON string.
b. Manually Inserting JSON Value
Alternatively, you can manually insert the JSON value into the parameter. Simply paste your JSON string into the value field of the parameter.
5. Saving the Parameter
Once you have inputted your JSON data, give your parameter a name and description for easy identification. Save your parameter by clicking the ‘Update’ button.
6. Using the Parameter in Your Dashboard
After creating the parameter, you can use it to control various aspects of your dashboard like a constant value in expression, stored procedure, code view, and Web URL, Web Headers/Raw Body, etc. For example, you can bind the parameter to a widget’s data configuration to filter data based on the parameter’s value.
In the below screenshot the created JSON parameter is used in the Raw Body of a Web Request.
Conclusion
By following these steps, you can successfully create dashboard parameters using JSON data in Bold BI. This allows for a high level of customization and interactivity within your dashboards, enhancing the user experience and providing more meaningful insights.
Additional References
