The Community Search page is currently unavailable. We are investigating this and hope to have a fix as soon as possible. Please use alternate search engines (e.g. Google) or navigate to your profile to find individual posts. Thank you!
Adding a total to a stacked column
Firebott
✭✭
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.
Tags:
Answers
-
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.
