Chart elements transform your data into visual representations that help identify trends and make comparisons. Each chart type offers unique ways to analyze and present your database records through calculations and groupings.
Chart Types
Bar Charts
Bar charts display data using rectangular bars of varying lengths to show comparisons among categories.
Key Features:
- Horizontal or vertical orientation
- Single or multiple data series
- Grouped or stacked layouts
- Custom bar colors and styles
Line Charts
Line charts connect data points with lines to show trends and changes over time.
Key Features:
- Multiple data series
- Curved or straight lines
- Custom point markers
- Interactive tooltips
Area Charts
Area charts fill the space below line chart data points to emphasize volume and trends.
Display Options:
- Basic area (single plane comparison)
- Stacked (cumulative values)
- Percentage stacked (relative to 100%)
Circle Charts
Circle charts display data as segments of a circle, showing parts of a whole.
Styles:
- Filled (traditional pie)
- Donut (hollow center)
- Custom segment colors
- Interactive labels
Configuration
Data Settings
Grouping Options
- Single grouping per chart
- Field-based grouping
- Date/time intervals
- Connection field filtering
Calculations
- Record count
- Sum
- Average
- Minimum
- Maximum
Note: Calculations are limited to 10,000 records per grouping
Visual Settings
Layout Controls
- Chart dimensions
- Legend position
- Title placement
- Description text
Style Options
- Color schemes
- Font settings
- Axis labels
- Grid lines
Interactive Features
User Controls
- Click-to-expand details
- Print functionality
- Data export options
- Tooltip display
Filtering Options
- User-defined filters
- Predefined filter menus
- Field-specific filtering
- Filter combinations
Best Practices
Design Guidelines
- Choose appropriate chart types
- Maintain clear data labels
- Use consistent colors
- Consider mobile display
Performance Tips
- Limit data points
- Filter large datasets
- Optimize groupings
- Cache calculations
Technical Limitations
Record Limits
- Maximum 10,000 records per calculation
- 3,000 grouping limit
- Formula field restrictions
- Connection depth limits
Grouping Calculations
- Row count × Column count × Calculations
- Example: 100 records × 3 categories × 2 calculations = 600 groupings
Troubleshooting
Common Issues
- Exceeding record limits
- Empty group display
- Calculation errors
- Display formatting
Solutions
- Add source filters
- Configure group filters
- Adjust calculations
- Modify display settings
Implementation Tips
Setup Process
- Select chart type
- Configure data source
- Set groupings/calculations
- Customize appearance
Optimization Steps
- Filter source data
- Limit groupings
- Streamline calculations
- Test performance
Warning: Source filters don't affect grouping counts - use group filters for large datasets
Tip: Enable "Exclude Empty Groups" to hide zero-value entries
Related Resources
- [Data Grouping Guide]
- [Calculation Methods]
- [Styling Options]
- [Filter Configuration]