Number Widget

The Numbers widget enables you to manually input numbers to query numerical data.

1. Drag the widget

1) Click on the Checkbox Group widget and drag it into the parameter pane. The widget name defaults to numberEditor0.

2) You are allowed to change the widget name. The widget name is used to bind the widget to a certain parameter. Specifically, the widget will be bound to a parameter when they have the same name. In the Preview mode, the values selected with the widget will be passed to the parameter.

 2. Disable the widget

1) Check [Enabled]. In the Preview mode, you are allowed to check the options the widget displays.

2) Uncheck [Enabled]. In the Preview mode, the widget has a shallow color and you are not allowed to check the options the widget displays.

 3. Hide the widget

1) Check [Visible]. In the Preview mode, the widget is visible.

2) Uncheck [Visible]. In the Preview mode, the widget is not visible.

 4. Widget value: Double

1) The default value first appeared in the Preview mode can be set to Double, Field and Formula.

2) If you select Double as the widget value, you can input an integer or numbers with a decimal point.

5. Widget value: Field

1) If you select [Field] as the widget value, you will further have dataset and field options to choose from.

2) In the demonstration, we choose ds1 and max_income.

 6. Widget value: Formula

1) Select [Formula] as the widget value. Click on the [=] and a Formula Definition window pops up.

2) In the demonstration, we input the following formula in the text box: sql("FRDemoEN","SELECT max(income) FROM sales",1,1).

7. Watermarks

1) Leave the box of field or formula in [Widget Value] empty. If you type a watermark text in the corresponding box in the right-hand pane, a light-grey watermark will be shown in the widget option box in the Preview mode.

2) After clicking on the widget, the watermark will disappear. So we can add watermarks to display texts or numbers.

 8. Font size

1) You are allowed to change the font size.

2) The font size is 12 by default.

9. Allow returning a null

1) If [Allow Null] is checked, it allows you to make a query without displaying any option.

2) In the Preview mode, no option is checked and no error tip pops up after clicking on Query.

10. Not allow returning a null

1) If [Allow Null] is unchecked, select at least one option for query.

2) In the Preview mode, no option is checked and an error tip pops up on the right side of the browser window after clicking on Query.

11. Allow decimals

1) If [Allow Decimals] is checked, you are allowed to select decimal digits.

2) If [Allow Decimals] is unchecked, you are not allowed to select decimal digits.

12. Allow negative

1) If [Allow Negative] is checked, you are allowed to input a minus sign in the Preview mode.

2) If [Allow Negative] is unchecked, you are not allowed to input a minus sign in the Preview mode

13. Need maximum value and minimum value

1) If [Need Maximum Value] and [Need Minimum Value] are checked, you are allowed to set the range of the maximum and minimum values, and input an error tip.

2) If they are unchecked, you are not allowed to set the range of the maximum and minimum values.

14. Widget position

1) Widget position refers to the coordinates of the widget in the parameter pane.

2) Manually input the widget coordinates or directly drag the widget to any position at your option.

15. Widget size

1) To resize the widget, put your cursor onto a border line and the cursor will change into a streamlined arrow, then click and drag.

2) Directly input the width and height of the widget.