Dashboard Creator - Part II

  • Article

Dashboard Creator – Part II

In a post last week, I introduced a Excel-based Dashboard Creator I wrote.

I gave examples of a dashboard showing counts. For example, the number of bugs assigned to a person.

But what if you want to show the sum-total of a field? For example, you can show the number of active tasks assigned to a person, but what is really interesting is the sum total of the remaining hours.

To do this, you can add the “SumField=” clause. With this clause, you define which field you want to sum up, and that is what will be displayed in the dashboard. In the example below, we are summing on "Remaining Work" for the tasks.

Sum Field Example

You must make sure that the field you are summing on exists in the Excel sheet specified by “SheetName=”.

If you are interested in more information on this dashboard creater, see previous posts. If you want to download the dashboard creator, you can find attached to this post.