Chart Widget = Edit Columns included in the Data Source

Hi everyone.

I am using a Project Dashboard template and I need to modify the Chart Widget to reflect the progress of the project by completion %. Unfortunately when I try to edit the column on Edit>Data & Chart type > Columns included I get this message. As a result the widget shows as 100% when in reality only 10% is completed.

Any ideas?


Tags:

Answers

  • Intern98
    Intern98 ✭✭✭

    Hi, you would need a separate column with the running total count and the running completed total count.

    you will need 2 cells.

    =countif([Complete]:[Complete],=1) to get number of complete projects

    =count([Assignee]:Assignee])-(the above cell) to obtain number of incomplete projects

    select these four cells like so for your data type.

    You will have to select switch rows and column if the heading seems wrong