In our project, we use another name to store value for facet chart instead of 'value' which is used by default. For example, 'val' is used as shown at below:
var data = {
subvalues: [{
subvalues: [{
name: "Playstation 3 (not set)",
val: 204
}],
name: "Playstation 3",
val: 204
},{
subvalues: [{
name: "Mozilla Compatible Agent 5.0",
val: 292
}, {
name: "Mozilla Compatible Agent 4.0",
val: 4
}],
name: "Mozilla Compatible Agent",
val: 296,
}]
};
When we export the chart to xlsx file, we noticed that there are 3 extra columns as shown at below:
The user normally may not want to see the 'id' and 'subvalues' (The number of children if I not mistaken) as they are not part of the original data. Besides that, 'value' column still exists which carry zero number and this may confuse the user. Can this three columns removed during exporting xlsx/csv file? This pie chart also have the same issue.
Thank you.