Advanced Reporting - Getting Started
Powered by Looker, Affinity's Advanced Reporting will enable you to create new, robust visualizations of your data and share them with others moving forward.
Note: Advanced Reporting is only available to a specific set of users at the moment, and will be available to everyone in early 2021 at an additional cost.
For those with early access, once your Affinity CSM has set it up for your team Affinity account, feel free to jump to the section most relevant to you:
- Getting started with Advanced Reporting
- How to download a dashboard (one-time)
- How to email a dashboard to others (one-time and recurring)
Getting started with Advanced Reporting
- Click the Reports tab on the top navigation bar.
- Click New to create a new dashboard, then click Edit Dashboard. You can also click the ellipsis (3-dotted icon) to edit the dashboard in the future.
- Give your dashboard a name (we suggest using the name of the list that will be used to generate the reports). Then, click Add Tile.
- You can choose from two types of tiles: Visualization or Text.
- Visualization tiles (shown in red) display quantities and metrics.
- Text tiles (shown in green) only allow text and serve as headers for different reporting sections of your dashboard.
- Given that visualization tiles will be used most frequently, click Visualization.
- Select the list you want to generate a visualization for. In this example, we will choose the Deals List.
- Given that this is a multi-step process, we've broken it down for you.
- First, name this visualization tile. In this example, we'll name it "Top Source of Introductions."
- Then, click the All Fields tab and select the dimensions (the fields) and measures (the unit of measurement) that will make up the visualization.
- You'll see the relevant data appear in the Data section. Click Run to see updates whenever you change your dimensions or measures.
- Now, click any visualization option to display the chosen dimensions and measures. You can choose from table charts, vertical column graphs, horizontal bar graphs, scatterplots, line graphs, area graphs, pie charts, maps, and single values.
- You can also apply filters to focus on specific field values. Click Run to see updates whenever you change your filters.
- Finally, click Run one more time after everything is set, then click Save.
- Now, you should see your newly-created visualization tile showing the relevant data.
- Repeat steps 2-9 above, and you'll have a dashboard that consists of multiple visualizations to keep track of different metrics and key performance indicators.
- Feel free to copy your dashboard URL and share it with fellow members on your team Affinity account.
- If you need to edit any tiles after they've been created, simply go back to Edit mode for the entire dashboard (see Step 2), then click the ellipsis (3-dotted icon) within the tile to make the necessary changes.
How to download a dashboard (one-time)
Once you've built out a dashboard, you can download it as a PDF or CSV and send it to others outside of your team Affinity account.
- Click the ellipsis (3-dotted icon), then click Download.
- Select one of two formats: PDF or CSV.
- The PDF format will display the visuals as is.
- The CSV format will consist of multiple CSV files containing the quantitative values shown in each visualization tile.
- If you choose the PDF format, select a Paper Size. If you have a long dashboard with many tiles, we would highly suggest sticking with Fit Page To Dashboard.
- You can additionally choose to expand tables to show all rows and not just a few.
- You can additionally choose to arrange dashboard tiles in a single column.
- You can click Open in Browser to see a preview of the PDF before choosing to download it.
- Once you approve of the PDF, click Download.
- If you choose the CSV format, simply click Download.
How to email a dashboard to others (one-time and recurring)
If you'd like to share your dashboard with others on a frequent basis, you can send it to your colleagues via email.
- Click the ellipsis (3-dotted icon), then click Schedule delivery.
- Select your preferred Recurrence and Time.
- Add all the email addresses you'd like to send this dashboard to.
- Select one of three formats: PDF, PNG, or CSV.
- The PDF format will display the visuals as is.
- The PNG format will display the visuals as is.
- The CSV format will consist of multiple CSV files containing the quantitative values shown in each visualization tile.
- Click Save and you're all set!