The QBeeQ Advanced Input Parameters plugin enables the end user to interact with the data on a dashboard by providing various types of numeric input boxes which can be referenced within advanced formulas in any widget. Extremely easy setup, no JS required at all!
This way, you can update, modify and create new data on the fly, from the front end, without having to add data into the Elasticube, empowering dashboards with full What-If Analysis capabilities.
Also, the designer can pull optional data into the Input Parameters from a table in the EC. In this method, the designer can determine what optional values will be available to the viewer. An example for this use case can be ratings of an app: the text which will appear on the viewer will be ‘1 Star’, ‘2 Stars’, … ‘5 Stars’, while the data inserted into the place holder will be 1, 2, … 5, respectively.
This plugin provides full design and configuration options for the designer. Once a new parameter is created, an alias is assigned to it. This way, the designer can reference the parameters’ aliases into any advanced formula by adding ‘@’ before the name of the parameter.
These parameters can be referenced into any advanced formula, including CASE/WHEN statements.
In the following example, the Total Quantity is multiplied by the Discount which you can now control and use to test different values to assess different what-if scenarios.
Dynamic Buckets Histogram example:
Slider and Data Selector example:
In addition to plain input boxes, this plugin can be enhanced with sliders, knobs and levers for even higher user engagement and adoption.
More applications:
- Custom Grouping
- Dynamic Buckets – Histogram
- Dynamic Thresholds
- Aggregated Dashboard Filters