Adding a total to a stacked column

Hi all, I am creating a dashboard with a stacked column metric of tasks by department, priority, and status. The stacks are coming from a metric sheet (see print screen). The end user wants a total of tasks by department either placed under the department name or at the top of the stacked column. Is this doable? And if so, how? Thanks in advance.

Find more posts tagged with

Dashboards

Accepted answers

All comments

Paul Newcome

You will need to flip your data so that departments are different rows and the statuses are the columns. Then you can use a formula in a text/number column to output the department with the total. Something along the lines of

="HR" + " (" + SUM([Not Started]@row:Low@row) + ")"

Then when you build your chart, you would use this new column as your labels.

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.