Time in Status

Widget title

Choose what to display in the title bar of the widget.

Data source

Select the type of Data Source used by the widget:

• The board of your Team.

• A Shared query containing the items for which you want the metrics to be calculated. Make sure that the specified query is shared with the users who will also visualize this widget.

What to measure

Choose what you want the widget to measure. You can chose between:

• Time in state - By selecting this option the widget will calculate the time in every workflow state that items reached during their life-cycle.

• Time in state category - By selecting this option the widget will calculate the time the items stayed in every state category: Proposed, In progress or Completed.

• Time in columns of the selected board - By selecting this option the widget will calculate the time the items stayed in every column of the selected board. This option can only be used with a Data source of type Team.

Calculation method

Indicates how calculate the time. You can choose between:

• Total time - By selecting this option the widget will calculate and display the time in state, category or board column by summing-up the time spent on all the items

• Average time - By selecting this option the widget will calculate and display the time in state, category or board column as the average duration by dividing the total duration to the number of items

Group data by

Optionally, you can choose to group the data by an item field, such as Assignee, Work Item Type, or Priority, of your choice.

Chart type

The type of the chart to be displayed by the widget.

If Group data by is set to None, you can choose from Column chart, Bar chart, Pie chart, or Stacked column chart. Otherwise, you can choose either Stacked column or Stacked bar.

States to process

Specify what states to be processed. You can choose one of the following options:

• Only states in these categories - The default option. If selected, the widget will only process states from the selected state categories. By default, only the Proposed and In Progress categories are selected; the Completed category is intentionally excluded because items in this state category will most likely remain in their current done-category state and the time in that state will continually increase, thus not being relevant for the analysis.

• All states except these - By selecting this option the widget will process all states reached by the items except those specified. This option is useful if you want to exclude certain states from the analysis.

• Only these states - By selecting this option the widget will process only the specified states.

• All states - By selecting this option the widget will process all all states reached by the items.

Calculate in

Choose the time unit in which the results will be displayed.

Don't count weekends

Check this option if you want to exclude the weekends (Saturdays and Sundays) when calculating the time in state.

Show legend

Check this option if you want the chart legend to be displayed.

Show data table

Check this option if you want a data table to be displayed along with the chart. The Data tab displays the items along with time in every state, state category or column of board depending on what you selected at What to measure on Data tab.

Open data tab first

Check this option if you want the widget to open on the Data tab first (instead of Chart tab as default). Note that the tab order will remain unchanged (Chart, then Data); only the initial view will switch to the Data tab.

Display states in this custom order

Choose the order in which you want the states to appear. This lets you control how they are displayed in the widget.

Automatically assign colors

Check this if you want the chart to automatically assign colors for the series.

Custom colors

Select any custom color you want the series to be displayed on by either entering the color's hexadecimal code or picking a color.

By default, only the common series are listed, but you can use the Add (+) button to add additional series to the table.

You can also use the Copy and Import buttons to copy and import the color configuration to widgets of the same type.