Chart Widget

Hello,

I'm creating a dashboard of a program status. I'll like to display a bar chart where I can see in the column the name of the Project and inside the number of activities per status.

Like a cumulative columns whit all the status per project

Vertical axes: #Task

Horizontal Task : Projects

Data display in a bar : # task per status

Is this possible?

Find more posts tagged with

Dashboards

Accepted answers

KT_H

Yes! You would need a sheet that has the data in question to create a dashboard from. Is this data being sourced from a project sheet?

Here is an example below:

I have a metric sheet that evaluates data from my project sheet.

Screen Shot 2022-07-26 at 3.31.34 PM.png

An example of the formula that calculates this would be =COUNTIF({Status}, "Complete")

This looks at the Status Column of my project sheet and looks for the status to match the value in quotes "Complete". This is showing that 20 tasks have been completed. I can then highlight this data in a dashboard widget.

Screen Shot 2022-07-26 at 3.35.27 PM.png

I can then highlight this data and add it to a dashboard chart widget.

To add titles to the axis you can edit that in the chart widget editor.

Screen Shot 2022-07-26 at 3.35.48 PM.png

All comments

KT_H

Yes! You would need a sheet that has the data in question to create a dashboard from. Is this data being sourced from a project sheet?

Here is an example below:

I have a metric sheet that evaluates data from my project sheet.

An example of the formula that calculates this would be =COUNTIF({Status}, "Complete")

I can then highlight this data and add it to a dashboard chart widget.

To add titles to the axis you can edit that in the chart widget editor.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.