Can we pivot text value instead of sum or count in pivot

[vijay@spinetechnologies]

Can we pivot text value instead of sum or count in pivot

Please find attach file expected result.png

Source data and expected result are mention in that.

[paramvir]

can you please share sample data so that I check its feasibility.

[vijay@spinetechnologies]

please find the attached text file which contains JSON data

[vijay@spinetechnologies]

as in previous file date was not in proper format

[paramvir]

Thanks for the JSON data. Yes, it works.

First define custom aggregate, you can name it anything.

Code: [Select]

pq.aggregate.custom = function( arr ){
return arr[ 0 ];
}

Then use that custom aggregate in groupModel:

Code: [Select]

var groupModel = {           
on: true, //grouping mode.
pivot: true, //pivotMode
titleIndx: 'Employee Name',
groupCols: ['Date'], //grouping along column axis.
agg:{ //aggregate fields.
DayType: 'custom'
},
header: false, //hide grouping toolbar.
dataIndx: ["Employee Name"], //grouping along row axis.
summaryEdit: false
};