Pivot Charts across All Categories

If plotting a pivoted chart where all categories should be included, the include_all_categories flag can be used. When this flag is enabled, all categories within the pivot_column_name will have as series dynamically generated based on the specified series.

• Each series will use a different color automatically, other formatting settings will be inherited from the series defined in the chart function

• The formatting options will be limited, so this should be used for charts where customizations per series are not necessary

• Series can still be stacked using the is_stacked flag

• Categories will be sorted on the legend in ascending order, but can be sorted on another column via the category_sort_column_name argument

import pandas as pd

from visualization_toolkit.helpers.plotly import chart, axis, series


fig = chart(
    pdf,
    x_axis=axis(column_name="fiscal_qy", label="Fiscal Quarter"),
    y1_axis=axis(label="Downloads", axis_type="number", axis_min=0),
    chart_series=[
        series(
            column_name="ios_dl_idx",
            mode="bar",
            is_stacked=True,
            pivot_column_name="region",
            include_all_categories=True,
            # sort categories by total downloads using the ios_dl_idx column
            # in descending order (the "-" indicates descending)
            category_sort_column_name="-ios_dl_idx",
        ),
    ],
)

fig