Modules
Objects/Functions
SuiteScript 2.0
// Please search https://system.netsuite.com/app/help/helpcenter.nl?search=workbook.ChartDefinition for more information.
N/workbook Module
workbook.ChartDefinition
Object Description:
A chart definition. A chart is a workbook component that enables you to visualize your dataset query results using predefined chart and graph types, such as line graphs and bar charts. A chart definition is used when you create a workbook.
You can create a chart definition using workbook.createChartDefinition(options).
Supported Script Types:
Server scripts
For more information, see SuiteScript 2.0 Script Types.
Module:
N/workbook Module
Methods and Properties:
ChartDefinition Object Members
Since:
2020.2
Search NetSuite -
https://system.netsuite.com/app/help/helpcenter.nl?search=workbook.ChartDefinition
Example:
// Code Example 1
// Add additional code
//...
// Create a basic ChartDefinition
var myChartDefinition = workbook.createChartDefinition({
name: 'myChartDefinition',
id: '_myChartDefinition',
type: workbook.ChartType.BAR,
category: myCategory,
legend: myLegend,
series: [mySeries],
dataset: myDataset
});
// Create a comprehensive ChartDefinition
var myChartDefinition = workbook.createChartDefinition({
name: 'myChartDefinition',
title: 'My Chart Title',
subTitle: 'My Chart Subtitle',
id: '_myChartDefinition',
type: workbook.ChartType.BAR,
stacking: workbook.Stacking.PERCENT,
category: myCategory,
legend: myLegend,
series: [mySeries],
filterExpressions: [myExpression],
aggregationFilters: [myLimitingFilter],
dataset: myDataset
});
// View a workbook.ChartDefinition
var myWorkbook = workbook.load({
id: myWorkbookId
});
var myChartDefinition = myWorkbook.chartDefinitions[0];
// Note that some ChartDefinition properties may be empty/null based on the loaded workbook
log.audit({
title: 'ChartDefinition id = ',
details: myChartDefinition.id
});
log.audit({
title: 'ChartDefinition name = ',
details: myChartDefinition.name
});
log.audit({
title: 'ChartDefinition title = ',
details: myChartDefinition.title
});
log.audit({
title: 'ChartDefinition subTitle = ',
details: myChartDefinition.subTitle
});
log.audit({
title: 'ChartDefinition legend = ',
details: myChartDefinition.legend
});
log.audit({
title: 'ChartDefinition category = ',
details: myChartDefinition.category
});
log.audit({
title: 'ChartDefinition series = ',
details: myChartDefinition.series
});
log.audit({
title: 'ChartDefinition stacking = ',
details: myChartDefinition.stacking
});
log.audit({
title: 'ChartDefinition filterExpressions = ',
details: myChartDefinition.filterExpressions
});
log.audit({
title: 'ChartDefinition aggregationFilters = ',
details: myChartDefinition.aggregationFilters
});
log.audit({
title: 'ChartDefinition dataset = ',
details: myChartDefinition.dataset
});
log.audit({
title: 'ChartDefinition type = ',
details: myChartDefinition.type
});
//...
// Add additional code
//SOURCE: https://system.netsuite.com/app/help/helpcenter.nl?fid=section_159007989923.html