These tools will allow you to format the data in a report and help you to organize it and make it easier to analyze.
_________________________
đ Columns and Filters Feature: Here is an example of using these tools to organize a Logged Hours Raw Data report to see the total hours by Activity and then broken down by Volunteer. Below, you will also find a video to demonstrate these steps.
1ď¸âŁ Choose criteria: First we select which fields to include in the report.
Note: We added Database User ID to help organize by volunteer.
2ď¸âŁ View Logged Hours & Open Columns view: After you select View Logged Hours to view the report, there is a small button on the right named âColumnsâ. Open this to see the options for Groups and Values.
3ď¸âŁ Drag and drop to organize: Drag and drop the different columns youâd like to use to format the data.
Group: The section will consolidate the data based on the columns you drag here.
Value: This section will total the values for the columns you drag here.
_________________________
đ˝ď¸ Columns and Filters Feature Demonstration Video:
Please note: the video includes the Activity Report Group field which is not present in all types of accounts.
_________________________
𤊠Admin Tip: Need a Chart? Highlight the data in the preview and right click to see the option for âChart Rangeâ. From here you can make a bar graph, pie chart, line graph and more!
_________________________
đ These help articles provide written instructions for the steps above:âŻ
_________________________
đ Click Here to Join a User Group! - They are a great way to learn more tips like this and connect with other administrators like you!