The dot chart is a composite chart with circles and lines. It is ideal for illustrating change while retaining the information about the absolute values
The plot is run for the chosen dimension.
The Actual, value is show with a black dot. The other value, is shown with a grey (if Previous year) or white (if Plan) dot. Red bands are "bad" while green bands are "good." Dots are accompanied by value labels.
SAVING THE PLOT
To save the plot as a PNG file, click on the small camera icon, and select "download as PNG".
Open the expander under the 📊 Plot type drop down menu by clicking on the ➕ sign.
Additional options are available for selection.
Use the menu to select the metrics and the dimensions you do not want to plot. The residual metrics and dimensions will be plotted.
Choose how many items you want to plot. The other items will be aggregated together.
Values can be plotted in absolute value, as a % of total dataset, as a % of total dataset after filters, or as a % of the result row. The last two options only make sense if you plot a result row.
EDIT AND MOVE LABELS
You can edit and move around plot titles and labels. In this chart..
...you can move the value labels around, delete them and adjust their position. For instance by inserting the "< BR > " tag we can show the title on three rows, according to the IBCS standard.
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
Add your message to the text box, one chart at a time.
Once you have finished writing the message for a chart, click on the 🚀 Submit.
Your message will appear above the chart title.
The downloaded image of the chart contains the message.
By default, 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.