Skip to content

DOT PLOT

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

PLOT DETAIL

The plot is run at the total plotted data level...

visualization

...and for each dimension.

visualization (1)

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".

image-20210702094601023

OTHER OPTIONS

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

Additional options are available for selection.

image-20210503175101792

By default all metrics present in the dataset are plotted. You can choose to plot only one metric, for instance "Amount".

image-20210503175239760

Only the Amount plot will be plotted.

visualization (2)

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

image-20210503175514686

The metrics will be plotted in the required order.

visualization (3)

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.