Create a simple table for dashboarding

What's the easiest way to create a very simple table which contains a summary of data from a grid which collects survey responses for dashboarding

I want to be able to create a summary by "Account" with a count of various statuses [see example below]

Account Open Closed

Apple COUNT Account = Apple & Status = Open COUNT Account = Apple & Status = Open

Beta COUNT Account = Beta & Status = Open COUNT Account = Beta & Status = Open

And so on for each account

Thanks

Dan

Find more posts tagged with

Dashboards

Accepted answers

All comments

Genevieve P.

Hi @Daniel Barrett

It sounds like creating a Report with Grouping and Summary applied may work for you!

See:

Webinar - Redesigned Reports with Grouping and Summary Functions

Help Articles - Reports / Configure Grouping to Organize Results in Report Builder / Summarize Content to Extract Key Information with Report Builder

If you're having trouble after reviewing the webinar above, I'd be happy to explain how to do this based on your specific sheet/process, but it would be useful to see a screen capture of your sheet (please block out sensitive data).

Cheers,

Genevieve

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.