In this issue I will be capturing some of the brainstorming as to possible features
Configurable Styling
A yaml config file can be stored in the home directory which specifies the base configuration of the styling.
Configurable Attributes
TODO
Automated Spacing
The automated spacing of charts on slides.
Custom spacing
Enable users to use customer spacings for their charts
Create New Slides/Sheets & Overwrite
The module can both create new slides & sheet objects to utilize but alternative can overwrite existing slides & sheets objects.
There are 3 possible use cases:
I create a new presentation to output my charts. I then copy and paste them into an existing presentation.
I have an existing presentation and I wish to update the charts in that presentations with up to date data
I have an existing presentation and I wish to add slides with chart to that presentation
Functionality
A google slides chart is just an image of a sheets chart
A google slides chart will render if the source google sheets is in the trash and deleted
Overwrite Error
Have an overwrite boolean that allows you to overwrite existing data, but if it's false throw an error.
Pull Current Information From Slide / Charts
Enable the user to pull information from existing deck so that they can understand styling, spacing and which object id's to overwrite
Visualize existing slides / information
Display png to help user visualize existing objects in sheets / slides so that they can make decisions on what to do
Chart Types & Styling
Combo charts?
There are some options that are not supported by the sheets API and might require the charts API
However there are many options supported by the sheets API and we will determine which ones to build
TODO create spreasheet on what is configurable for each chart type
Tables
Enable convenience functions that allow users to create styled table with data in a presentation
Custom Body
Enable users to input custom API calls along with the convenience calls to add objects to the slides as they please
Date Handling
Accept the following type of datetimes
str
datetime
TODO
Validate Scope
Ensure that when the connection is passed the user has both spreadsheets and sheets permissions
X Axis / Y Axis / Legend Ordering
Provide ability to order the axis
Validation of Data
Nulls?
Dups?
Grouping into other
For series that are small enough, group them into an other series
Features
In this issue I will be capturing some of the brainstorming as to possible features
Configurable Styling
A
yamlconfig file can be stored in the home directory which specifies the base configuration of the styling.Configurable Attributes
TODO
Automated Spacing
The automated spacing of charts on slides.
Custom spacing
Enable users to use customer spacings for their charts
Create New Slides/Sheets & Overwrite
The module can both create new slides & sheet objects to utilize but alternative can overwrite existing slides & sheets objects.
There are 3 possible use cases:
Functionality
Overwrite Error
Have an overwrite boolean that allows you to overwrite existing data, but if it's false throw an error.
Pull Current Information From Slide / Charts
Enable the user to pull information from existing deck so that they can understand styling, spacing and which object id's to overwrite
Visualize existing slides / information
Display
pngto help user visualize existing objects in sheets / slides so that they can make decisions on what to doChart Types & Styling
Combo charts?
There are some options that are not supported by the sheets API and might require the charts API However there are many options supported by the sheets API and we will determine which ones to build
TODO create spreasheet on what is configurable for each chart type
Tables
Enable convenience functions that allow users to create styled table with data in a presentation
Custom Body
Enable users to input custom API calls along with the convenience calls to add objects to the slides as they please
Date Handling
Accept the following type of datetimes
strdatetimeValidate Scope
Ensure that when the connection is passed the user has both spreadsheets and sheets permissions
X Axis / Y Axis / Legend Ordering
Provide ability to order the axis
Validation of Data
Grouping into other
For series that are small enough, group them into an other series
Pivot Column
Allow user to pivot on a column
Draw
Allow user to draw a line on the chart