Histogram properties

Click the dimension name to open the dimension settings.

If you want to delete the dimension, long-touch/right-click the dimension and select Delete in the dialog. Alternatively, click the dimension and click DeleteÖ.

If you have added a field from Fields in the assets panel, the field name is automatically displayed. Click 3 to open the expression editor.

On the Data tab, under Dimensions, click Add to open a list of available Dimensions and Fields. Select the dimension or field that you want to use.

You can also click 3 to create a dimension in the expression editor. To be able to edit a dimension that is linked to a master item, you must first unlink the dimension. Another way to create a dimension is to type the expression directly in the text box. Expressions added in this way must begin with an equals sign (=). Here is an example with a calculated dimension:

=If (Week < 14, Week, 'Sales')

If Add is dimmed, you cannot add more dimensions.

You can set Bars to Auto or Custom.

• Auto divides the data into the optimal number of bars based on the current data selection. You do not need to make any other settings. The calculation is based on Sturge's formula.
• Custom lets you define how to divide the data into bars.

Set Width to define how wide each bar is. This is based on the values on the x-axis.

You can offset the bars by changing the Offset setting.

Example:  

If you set Width to 2 and keep the default Offset setting 0, your bars may be defined 0 to 2, 2 to 4, 4 to 6, and so on. If you change Offset to 1, the bars are defined -1 to 1, 1 to 3, 3 to 5, and so on.

Calculation condition: Specify an expression in this text field to set a condition that needs to be fulfilled (true) for the object to be displayed. The value may be entered as a calculated formula. For example: count(distinct Team)<3. If the condition is not fulfilled, the message or expression entered in Displayed message is displayed.

A calculation condition is useful when a chart or table is very big and makes the visualization slow to respond. A calculation condition can then help so that for example an object does not show until the user has filtered the data to a more manageable level by applying selections.

Include zero values: When unselected, measures that have the value ‘0’ are not included in the presentation. If there is more than one measure value, all the measure values must have the value ‘0’ to be excluded from the presentation.

Show titles: On by default in all visualizations except filter panes, KPIs, and text & image visualizations.

Enter Title, Subtitle, and Footnote. By default, the string is interpreted as a text string. However, you can also use the text field for an expression, or a combination of text and expression. An equals sign (=), at the beginning of a string shows that it contains an expression.

Click 3 if you want to create an expression by using the expression editor.

Example:  

Assume that the following string is used, including quotation marks: 'Sales: ' & Sum(Sales).

By default, the string is interpreted as a text string and is displayed as presented in the example. But if you begin the string with an equals sign: (='Sales: ' & Sum(Sales)), the string is interpreted as an expression instead. The output is then Sales: <value of expression>, where <value of expression> is the calculated value.

Show details: Set to Show if you want to allow users to be able to choose to view details, such as descriptions, measures, and dimensions.

Gridline spacing: Set this to Custom if you want to customize the horizontal gridlines. You can choose between:

• No lines
• Medium
• Narrow

Value labels: By default, Off. With the Auto setting, the value labels are displayed when there is enough space.

You can only set the bar color of the histogram.

Position: Select where to display the measure axis.

Range: Select to set the min value, the max value, or both. The min value cannot be larger than the max value. You can use expressions for the values.