Filter multiple sheet entries to display graph/total quantities on a dashboard

Hi Team,

I have a sheet that is a total list of materials used on a job, divided into columns showing material type, size, length, quantity. Each day materials are removed from the store a record is entered into the sheet. I am wanting to display a summary or total of each type of material on a dashboard. I'm open to ideas on how to achieve this or some direction if this question has been raised before.

Thank you.

Find more posts tagged with

Accepted answers

jjg279

It sounds like you could use a report then put that on your dashboard. Use the columns to select what things you want to displace (Material name and type?) then use the "Group" to group by type and the "Summary" to get your totals.

Would look something like this:

All comments

jjg279

Would look something like this:

Mrsnic

Hi Jessie,

Worked perfectly, thank you for taking the time to reply.

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.