Modules

filter

 

Objects/Functions

module (N/workbook)

SuiteScript 2.0

workbook.ChartDefinition

// 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