| Data Type | Visualizations Supported | X-axis aggregation logic (when moving off of ‘Day’) |
|---|---|---|
| Numeric (Decimal, Integer, Dollar) | Line, Table | SUM, AVG, MAX, MIN, Last date |
| Numeric (Health) | Line, Table | AVG, MAX, MIN, Last date |
| Calculated Fields | Line, Table | SUM, AVG, MAX, MIN, Last date |
| Picklist | Line, Table | Last date |
| True/False (Boolean) | Table | Last date |
| Date and Time | Table | Last date |
| Date | Table | Last date |
| Text | Table | Last date |
| Text Area | Table | Last date |
| Single-Reference fields | Line, Table | Last date |
| Multi-Reference fields | Table | Last date |
| Rich Text Area | Table | Last date |
<aside> 🗣️ After selecting a field type, if the user selects a “timeframe” away from the default offered, we should intelligently auto-toggle the “time interval” to a value that’s intuitive. The user will be able to re-configure these should they please.
</aside>
| “Set a timeframe to measure” (first user selection) | “Aggregation type” (if non-Health numeric field type) | “Set timeframe interval” |
|---|---|---|
| DAY (default) | N/A | DAY |
| WEEK | SUM | DAYS |
| MONTH | SUM | WEEKS |
| QUARTER | SUM | MONTHS |
👉 Aggregation Type default for Numeric Health Score should be “Last date”
👉 Until we allow users to configure their Fiscal Quarters, the “Quarter” outputs will be by calendar year