Hello,
I have a dynamic extraction system implemented that uses (today) the datatable component as output. That is working well, but we want to improve user experience using pivot table as the output so he can organize, filter and do calculations with the output data.
Important information to begin: since the data retrieved is dynamic (user will choose which information should be available), we don’t know how is the data. Could be {name: '1001', amount: 34.5}
as could be {year: 2017, identifier: '22', production: 23.2}
.
Questions:
-
The very first question is if it’s possible to translate the data keys with pivot. For example, if the data is
{ 'site.name': 'SomeName'}
instead of showing ‘site.name’ in the fields list and column header, show ‘Site - Name’. -
Sometimes, we retrieve empty data for some records. For example, If I have two entries in my data:
{name: 'SomeName', year: 2015, production: 12}
and{name: 'DidNotProduced', year: '', production: ''}
, and want to see the production per year of all sites, I end up with aundefined
column with no data. It is possible to not have that?
Obs: I wanted to do a snippet to show the problem, but I don’t have access to pivot table in the webix snippet.