HISTOGRAM
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.
To preserve performance, only one dimension will be plotted at a time. You can choose which dimension to plot with this widget.
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.
A sub plot is also run for each item of the chosen dimension.
By clicking on a legend value you can filter that value on the charts.
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.!
OTHER OPTIONS
Open the expander under the 📊 Plot type drop down menu by clicking on the ➕ sign.
Additional options are available for selection.
CHOOSE DIMENSION TO PLOT
Select the dimension to plot by item.
NUMBER OF TOP ITEMS
You can change the number of top items.
The above settings will return a plot that looks like this.
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.
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.
The chart above now looks like this, having filtered out the prices over 500.
CUMULATIVE CHART
You can plot the chart as cumulative.
It will show the % of prices below a certain value.
EDIT AND MOVE LABELS
You can edit and move around plot titles and labels. In this chart..
...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
ADD PLOT MESSAGE
It is possible to add messages to the chart, in the style suggested by the IBCS standard.
Add your message, one chart at a time, in the text box.
Once you have finished writing the message for a chart, click on the 🚀 Submit button.
Your message will appear above the chart title
Now write another message on the text box of a different chart.
Click submit. Your second message appears above the second chart.
The downloaded image of the chart contains the message.
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.