I cannot select a chart type other than "Table"
If you specify any of the following fields in the "Graph Contents" section of the chart setting, you will only be able to select "Table" for "Chart Type."
- Date
- Time
- Date and Time
- Created datetime
- Updated datetime
- Calculated (If "Date & time," "Date," "Time," Hours & minutes,"or "Days & hours & minutes" is selected as the display format)
If you want to display your aggregate result in a chart of another type, consider using the workarounds described below:
- Export the aggregate result in the table format to a file. Then, import the file data into the "Number" field of a new app and convert the data into a chart other than a table.
Make necessary changes to the exported file before importing it.
Exporting an Aggregate Result to a File
Creating App from Excel File
Creating App from CSV File - Export the aggregate result in the table format or the record data to a file and then use a different tool (e.g. Excel) to create a chart of your choice.
Exporting Data to a File