Skip to content

HISTOGRAM PLOT

The chart is a representation of the distribution of numerical data (for example prices), where the data are binned and the count for each bin is represented.

For reasons of performance, the dataset can be sampled down if it is larger that a set number of rows.

The sampling is required to preserve performance and brings all dataset down to a set number of rows. If your dataset is very large, this could limit the significance of the distribution plots.

image-20211112115458085

To preserve performance, only one dimension will be plotted at a time. You can choose which dimension to plot with this widget.

image-20210421171230481

In accordance to the IBCS standard notation the most recent, measured, Actual data is plotted dark grew while the past (example previous year) data is plotted light grey. Plan data is also plotted light gray (instead of white boxed) due to technical limitations.

PLOT DETAIL

The plot is run at the total plotted data level.

histogram

A sub plot is also run for each item of the chosen dimension.

histogram (1)

By clicking on a legend value you can filter that value on the charts.

image-20211112115829324

SAVING THE PLOT

To save the plot as a PNG file, hover and click on the small camera icon on the top left side of the chart.!image-20211112120105513

OTHER OPTIONS

Open the expander under the 📊 Plot type drop down menu by clicking on the ➕ sign.

Additional options are available for selection.

image-20211112120237807

CHOOSE DIMENSION TO PLOT

Select the dimension to plot by item.

image-20211112122045788

NUMBER OF TOP ITEMS

You can change the number of top items.

image-20211112122024970

The above settings will return a plot that looks like this.

image-20211112122152838

EXCLUDE OUTLIERS

You can also exclude outliers from the plot.

For instance the app might return this histogram that shows outliers in the 500 to 3500 price range.

image-20211112120422097

If the Exclude outliers widget is set to True, another widget will appear to choose beyond how many standard deviations a data point will be considered an outlier.

You can, for example, exclude all values beyond three standard deviations.

image-20211112120853402

The chart above now looks like this, having filtered out the prices over 500.

image-20211112120929122

CUMULATIVE CHART

You can plot the chart as cumulative.

image-20211112121212891

It will show the % of prices below a certain value.

image-20211112121358571

EDIT AND MOVE LABELS

You can edit and move around plot titles and labels. In this chart..

image-20211112122355686

...click on the titles and labels to, for example, change the title from bold to italic (change HTML tags from H-tab to I-tag), or move around and change the values of the labels and legends

image-20211112123014792

ADD PLOT MESSAGE

It is possible to add messages to the chart, in the style suggested by the IBCS standard.

image-20210907103349777

Add your message, one chart at a time, in the text box.

image-20211112123407016

Once you have finished writing the message for a chart, click on the 🚀 Submit button.

Your message will appear above the chart title

image-20211112123500601

Now write another message on the text box of a different chart.

image-20211112123815300

Click submit. Your second message appears above the second chart.

image-20211112123807290

The downloaded image of the chart contains the message.

image-20211112123838477

CHART TITLE

The chart title is set on three lines: the first line contains the reporting unit ("who"), the second line the business metric ("what") and the third line the time period ("when").

You can adjust the position of the title, the message text and the horizontal line by moving them around with the mouse.

histogram

Back to top