Tables are a powerful tool in your reporting belt! They can show detailed aggregate information about your data and are quicker to load than either charts or crosstabs. Here's a few tips to make the most of your report tables.
Step 1. Select the visualization type
- Create a new ad hoc view.
- When in the ad hoc view editor, select the bar graph symbol on the toolbar.
- Select the Table type and click Apply and Close.
You may notice that the Rows label switches to Groups. This is a good way to double check to make sure you've correctly switched to a table view.
Step 2. Group your data
Grouping your data by fields can help organize it. Depending on the fields you select for your columns, you can reveal different types of data for each transaction, cause or user.
Please note: If you want data on all users, limit the number of fields you add in the Users group.
Step 3. Change the view
In the upper left corner of the ad hoc view, you’ll see the gear cog symbol, which you can use to change how much detail you see in your table.
- Detailed Data shows the details per row, and is the default view.
- Totals Data shows the aggregate of the rows for each group. Like a crosstab, you can change the aggregation of the columns. This is the type of view used in your monthly donation report (a record of transactions).
- Details and Totals is a combination of the two views. It shows the details per row and the aggregates of each group.
You’ve created the table and grouped the data. Now you can save the ad hoc view as a report, schedule it, or export it into a different format like PDF or PPT. Here's some more how-to articles on those other tasks.
- Save or export your report
- Schedule a report
- Create a report on your top 10 causes
- Create a report on your popular cause categories