Set up a Historical values report
Track how your data has changed over time with Historical values reports.
This article explains how to set up a Historical values report, which shows how your data changes over time, helping you measure progress and identify trends.
Create a Historical values report
See Attio Academy for a video walkthrough of Historical values reports.
Note: Historical values reports are only available on Pro and Enterprise plans.
Historical values reports use time as the X axis, and you can choose the interval: daily, weekly, monthly, quarterly, or yearly. Unlike insight reports, you can’t choose a custom date attribute here, because historical reports are based on the state of your data as it existed at the end of each time period.
Follow these steps to set up a Historical values report:
Click Reports in the sidebar, then create or open a dashboard.
Click + Add report and choose Historical values.
Data source: Select an object or list.
Metric: Choose what to measure. Count records, or select a number, currency, or rating attribute for the y-axis.
If you choose an attribute, pick how to aggregate the data: Count, Max, Average, Min, or Sum.
Segment by: Optionally choose a status, select, or user attribute for color-coded bars or lines.
Current: Groups data by each record’s current value today. For example, if a $50,000 deal is now Won, the $50,000 will appear under Won for every month in the chart, regardless of its past values.
Historical: Groups data by the value each record had at the end of each period. For example, if a $50,000 deal was in Negotiation at the end of November and Won at the end of December, the chart will show $50,000 under Negotiation for November and under Won for December.
Filters: Optionally add filters to narrow the data.
Filters use the current values of records or list entries (not their historical values).
Visualization: Choose how to display the data: Bar or Line.
Use line charts to track trends, bar charts to compare categories.
Stack bars: Display bars stacked vertically or side by side on bar charts.
Show axis labels: Toggle attribute names on or off.
Target: Add a target value to display a goal line across the chart.
Time period: Above the chart, choose Daily, Weekly, or Monthly, and select the period to display.
Compare: Show current and previous periods side by side to spot growth or decline.
Next steps
Changes you make to a report are not visible to other team members until the report is saved. For details on saving, viewing, and filtering reports, see Create reports.