Pivot rows formating

Hi, in my case i have rows: [“date”], getting from backend in string (d-m-Y).
But i need sort for date as date, because pivot sorting date with first number(11(this)-09-2015)

hello :wink:

Hi,

It is not very pretty, but possible.

http://webix.com/snippet/3f57f2ac

The above code adds $scheme to convert date string to date objects, and later uses onDataLoad event to sort data before rendering the pivot.

We’re looking for this feature too.

I think this is the final feature that we need before we can commit to purchasing a pro license. Is this available yet?

Good day @violuke ,
The Pivot and most of our complex widgets (except Kanban and Spreadsheet) are built as modularized apps on Webix Jet, and the user can customize existing modules or add new ones.
Modules are implemented as JetViews (ES6 classes) where any UI element, data-related service, or feature can be customized by the same rules. For more details about this architecture, please check the following blog article, which describes the general idea and reasons for this structure.

Please note that complex modifications may require observing the source code of the tool in order to build the most feasible solution that will correctly alter/extend the original logic.

Pivot includes a math engine for data calculations. It is not available for direct customization, but in the Pivot itself, you can customize the call to the addDimension method and the parameters passed there: Code Snippet (e.g add sort at line 24).

And here is an example with “date” row where to sort string dates we need first to convert them to Date objects: Code Snippet .

1 Like