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 at the total plotted data level...
...and for each dimension.
The most recent, Actual, value is show with a black dot. The less recent, or Plan, value, is shown with a grey dot. Red bands are "bad" while green bands are "good." Dots are accompanied by value labels. If the value labels are too close and would overlap, the app tries to show only one label
SAVING THE PLOT
To save the plot as a PNG file, click on the small circle to the right of the legend, and select "save as PNG".
Open the expander under the 📊 Plot type drop down menu by clicking on the ➕ sign.
Additional options are available for selection.
By default all metrics present in the dataset are plotted. You can choose to plot only one metric, for instance "Amount".
Only the Amount plot will be plotted.
You can also change the order of the plot metrics. For instance instead of Amount, then Price, then Units, you can choose a different order
The metrics will be plotted in the required order.
By default, the ten top items in terms of total Amount of the two periods are plotted, while the other items are aggregated together.
You can change the number of top items, and you can choose not to plot the value of the other aggregated items.
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.