google-apps-scriptgoogle-sheetsgoogle-visualization
How to set the chart editor option “Aggregate” in Google Chart API
I want to set the option "Aggregate" (with value max), available in the Google sheet chart editor, through program code with the Google chart API.
I don't find any information on the Google chart API documentation.
Some help will be appreciated !
Solution
I have found this option which is not documented : .setOption('applyAggregateData',0)
- Graphical buttons in my Google sheets don't keep their position
- Trouble getting log function to work in a custom function for Google sheets
- Display pasted cells temporarily then return to main page
- Execution order of GS files in a Project
- Javascript case sensitive
- How do you add UI inside cells in a google spreadsheet using app script?
- Google apps script missing
- sharing the folder created by google form and google script
- "TypeError: Failed due to illegal value in property: 0" when sending a Map object to Apps Script server
- Lock google sheets for data entry after a wrong entry
- Schedule View: INDEX MATCH from table and return multiple cells into one
- How to combine 3 multidimentional arrays using GAS?
- How to Show/Hide rows in google sheets using a script?
- Popping a Modal Dialog when changing the drop down entry in Google Sheets
- Transfer background color from cell range to drop down options
- What do I do if my Apps Script didn't save?
- List Google drive folder contents to google sheets with only new files
- Finding the optimal division of an array
- Failed due to illegal value in property: context
- Formatting Specific Portions of a Gmail Email Created with Apps Script
- Extracting report data from Kickserv API into Google sheet using google Apps Script
- How to use the cell number instead of its value in a Filter + Importrange
- Google Docs Apps Script Extension Add-ons - Greyed Out after Installation
- I want to use a macro to check a value in a sheet and return one of two values
- How to union ranges in google spreadsheets
- Gemini 1.0 Pro Vision has been deprecated on July 12, 2024. Consider switching to different model, for example gemini-1.5-flash
- How to use Apps script to move a lot of data rows at same time to different spreadsheet automatically base on time
- How can I see the full server response for this API error message in Google Scripts?
- Can I list all my scripts without any other types of documents in Google Drive?
- Custom Menus Google Apps Script