The Empirical Cumulative Distribution chart is a representation of the distribution of numerical data (for example prices), that, for each point, shows the fraction of observations of the measured variable that are less than or equal to the specified value.
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.
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.
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.
You can plot the chart as reversed so that the right-most point is at 1 (or the total count/sum, depending on
ecdfnorm) and the left-most point is above 0 .
It will show the % of prices above 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
It is possible to annotate charts with lines, rectangles and circles. It is possible to modify the shapes and move them around, and delete them.
Hover and click on the "draw line", "draw circle" and "draw rectangle" icons on the menu bar on the upper right of the chart.
Draw and edit your shapes.
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.
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.