...
数据脚本样例:
for(var i = 0; i < data.length; i++){
var row = data[i];
if(row["column1"] == null || row["column1"] === "value"){
row["column2"] = row["column3"]/row["column4"];
}
}
return false;
Code Block | ||||
---|---|---|---|---|
| ||||
var newData = [];
var keepItemsCount = 4; //保留的数据量,对其它数据进行合并
var measureName = "数量"; //度量字段名
var dimName = "尺寸"; //维度字段名
var mergeLabel = "其它"; //合并后的数据值
var totalData = 0;
for(var i = 0; i < data.length; i++){
if(i < (keepItemsCount+1)){
newData.push(data[i]);
}else{
totalData = data[i][measureName] + totalData;
}
}
newData[keepItemsCount][measureName] = totalData;
newData[keepItemsCount][dimName] = mergeLabel;
data.splice(0,data.length);
for(var i = 0; i < newData.length; i++){
data.push(newData[i]);
}
return false; |