In addition to initial values and configuring chart from UI (available for user), it is possible to set its configuration via define+render methods after init:
$$("pivot").define("structure", {
groupBy: "year",
values: [{name:"balance", operation:"max"}]
});
$$("pivot").render();
In the next release, for the same purpose will be available setStructure method (already implemented in Pivot Table).
the number of categories increases over time
Here’s an example of implementation.
The only limitation so far is that the unused fields for stacked bar have to be defined as 0 in order to avoid any issue:
https://snippet.webix.com/oqulf0jy
We will consider the improvements for this behaviour.