AREA PLOT

The area chart shows the evolution of the available metrics over time. It requires a Date column in the dataset.

PLOT DETAIL

The plot is run for each dimension.

visualization

By clicking on a legend value you can highlight that value on the charts.

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

OTHER OPTIONS

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

Additional options are available for selection.

CHOOSE METRIC

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 for all dimensions.

visualization (1)

visualization (2)

You can also change the order of the plot metrics. For instance instead of Amount, then Units, then COGS, you can choose a different order

The metrics will be plotted in the required order.

visualization (3)

visualization (4)

NUMBER OF ITEMS TO PLOT

By default, the four 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.

NORMALIZED AREA PLOT

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.

If you choose any of the last three options (aka to plot as %) you get a normalized stacked area chart.

visualization (6)

visualization (7)

MOVE OR HIDE LABELS

Label placing might fail. For instance, the Action Figure, Splash Balls labels (as well as a few others) are not where they should be.

visualization (9)

To correct this, you can download the file as a SVG and use any SVG editing tool to reposition the labels.

Alternatively, you can simply decide not to show any labels.

visualization (3)

PLOT AS STREAMGRAPH

If "in absolute values" is selected in the "Plot values" widget, you will be prompted to choose between a standard area chart and a streamgraph.

A streamgraph is a type of stacked area graph which is displaced around a central axis, resulting in a flowing, organic shape. Label placing might fail with this graph.

visualization (1)

RESAMPLE

Resampling data means aggregating time series by a new time period. For instance this chart has monthly values, one data point per month.

visualization (8)

We could resample it bi-monthly to get one data point every two months.

After hitting Submit the chart is smoothed out.

visualization (9)

CHOICE OF COLOR PALETTE

You can choose one of the nine available color palettes. Six are inspired by Mekko Graphics, the other are default Tableau and PowerBi palettes, and a palette inspired from the IBCS examples.