Display chart that shows no. of tasks assigned to each person based on priority

Arundhati R

I created a report that is grouped by 'Assigned To' and then 'Priority'. I also have summarize on for both columns. I want to chart this data in stacked columns on my dashboard to show the no. of tasks that are assigned to each person based on priority. Ex. Bob is assigned 3 High priority tasks, 2 medium tasks, and 4 Low priority tasks. Bill is assigned 1 High priority task, 4 Medium priority tasks, and 2 Low Priority tasks.

I tried creating the chart and attached image is what I see. How can I fix this?

jmyzk_cloudsmart_jp

Hi @Arundhati R

"To chart this data in stacked columns on a dashboard to show the no. of tasks that are assigned to each person based on priority", I created a metrics sheet as shown in the image below. (Second sheet on the right.)

The formula for the Low column, for example, is as follows;

=COUNTIFS({Priority}, "Low", {Name}, Name@row)

I was not able to create a chart like the one on the right with a summarized report, as shown below.

https://app.smartsheet.com/b/publish?EQBCT=f27460ef62dd4aff8ae975aaf6ebe653