I have a large board with hundreds of items. One column displays total enrollment of students and another column displays demographic totals. I’ve figured out how to total those numbers on a display board using numbers widgets. Is there a way to display those same numbers as percentages based on the sum of specific selected columns?
Example: 40,000 students total and 30,000 students are English Language Learners. I’m able to display both of these numbers individually, but how can I also display 75% of students are ELL?
I have 5 columns related to demographic data of a single item (row). Those items are then put into groups based on a status column.
I’ve created a widget dashboard to display the totals of each demographic column with filters for various groups/status.
I want to display those same numbers, but as a percentage of the total sum of those columns. I’ve created the formula column to sum the 5 demographic columns, but I can’t find a way to display percentages either as individual numbers or on a pie chart.
If I’m understanding you correctly, this would be a neat set of data points to have. What you’re trying to calculate though: percentages based on the summed, filtered totals of multiple number columns, can’t be done at the dashboard level. Dashboards can display aggregates, but they can’t perform math on those aggregates.
That said, I think I have something for you that could work reasonably well if you keep everything item-level.
Since each item has:
5 demographic number columns, and
a formula column that sums them into a total,
You can add five additional formula columns, one per demographic, that calculate the percentage per item. (If that’s too visually messy for you, remember you can collapse the columns too.) Set each of those formula columns to display as a percentage. Just keep in mind these percentages are item-weighted, not total-count-weighted.
If you need exact percentages of summed counts, the data has to be restructured. There’s no dashboard-only workaround.