Duration column chart for a dashboard

NeuerNutzer

Hey,

I am trying to build a chart that shows me the duration of the tasks. I would like this to be a bar chart, so i can see how long each task took in comparison (these are the same tasks in different projects that take people different amount of time).

I am unable to use a report that shows the primary column and the duration column, that is auto calculated for the gantt chart. Am I missing something? Do I need another column that calculates the duration with a formular?

Thanks a lot !

SteyJ

https://community.smartsheet.com/discussion/112910/duration-column-chart-for-a-dashboard

Whenever mapping out data I always try to create tables.

In this instance, what I would do is create my own table and it would look something like this:

Column names

Task | Duration (Value of duration in hours or days)

Cell data

task name | value

now you can map task name to y, and the value to x via chart on dashboard.

jmyzk_cloudsmart_jp

Hi @NeuerNutzer

If you set "dependency enabled" at the Project Settings, which you usually will do, you can not use the duration column in the dashboard chart widget.

So, as you wrote above, You "need another column that calculates the duration with a formula."

The formula is straightforward, though.

Example:

Duration (In Days) = Duration@row

Then, you can use this value to create a chart.

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

The example below uses Report as the Chart source, whose base sheet uses conditional formatting to highlight durations greater than 7.

As you mentioned, you can not remove or hide a primary column in a report, but it acts like a Bar chart's series label.