how many ongoing and done to show using a pie chart?

hello,

how many ongoing and done to show using a pie chart? please suggest ideas. I appreciate any help. Have a nice day

Answers

  • NickStaffordPM
    NickStaffordPM ✭✭✭✭✭

    Step 1: So you will make a metric within the Sheet Summary function on the sheet A3 Database. One metric will be a COUNTIF referencing the the ONGOING steps and one will be a COUNTIFS referening the DONE Steps

    Step 2: Then you create a Sheet Summary Report based on the A3 Database, pull in both of those metrics you created.

    Step 3: Create a dashboard, select Pie Chart and have the data be the Sheet Summary Row Report Referenced in Step 2