Creating Line Chart Across Quarters

I’m trying to build a dashboard that shows a line chart of average quarterly survey scores for each recruiter. Here's what I want to achieve:

Each line represents a recruiter.
The X-axis shows quarters (e.g., Q1 2025, Q2 2025, etc.)
The Y-axis shows the average survey score
I want to visualize trends over time for each recruiter
I’ve already:

Created a helper column that calculates the quarter from the survey date
Built a report that summarizes average scores
Tried grouping by recruiter and summarizing scores
But I can’t get the chart to show multiple lines represnting each recruiter, with points for each quarter.

Has anyone successfully built a chart like this? Do I need to restructure my report or sheet differently? Any tips or examples would be greatly appreciated!

Thanks in advance!

Find more posts tagged with

Reports

charts

Accepted answers

Paul Newcome

I would suggest a separate sheet. Your sheet structure will depend on what requires the most frequent updates. Whichever data point (person or quarter) will be updated most frequently, make that your rows and the other your columns.

Then you would use formulas with cross sheet references to get your averages (use an AVG/COLLECT combo to get the filtered average by person by quarter) and chart from there.

All comments

Paul Newcome

Then you would use formulas with cross sheet references to get your averages (use an AVG/COLLECT combo to get the filtered average by person by quarter) and chart from there.

jeanine

Thank you! I was able to do it from a seperate sheet.

Paul Newcome

Happy to help. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.