Dashboard - Show progress using project phases not %s

I'm trying to create a visual in my dashboard that allows me to show where the project is at based on our standard project phases.

Vertical axis - list of project names

Horizontal axis - Project phases (01-Kickoff, 02-Discovery, 03-Build,...etc.)

Right now I can only show % complete but I'm trying to show the additional context of the stage.

Here is a simplified picture of what I'm going for.

Find more posts tagged with

Accepted answers

Genevieve P.

Hi @Weinrich.Jason

The Chart Widget will need numerical values to identify where the bar should stop along the X-Axis. What I would do in this instance is set up a helper column in your source sheet that automatically assigns a numerical value to each of your stages, like you have already.

For example, you could use a formula like this:

=IF(Stage@row = "01-Kickoff", 1, IF(Stage@row = "02-Discovery", 2, IF(Stage@row = "03-Build", 3, IF(Stage@row = "04-Test", 4, IF(Stage@row = "05-Launch", 5)))))

Screen Shot 2022-02-10 at 12.45.02 PM.png

Then once you have a number associated with each Phase, you can map this in a Chart. I would add a separate Text widget to create your custom legend, explaining what each number represents:

Screen Shot 2022-02-10 at 12.50.39 PM.png

See: Create a Chart for a Dashboard

Cheers,

Genevieve

All comments

Genevieve P.

Hi @Weinrich.Jason

For example, you could use a formula like this:

=IF(Stage@row = "01-Kickoff", 1, IF(Stage@row = "02-Discovery", 2, IF(Stage@row = "03-Build", 3, IF(Stage@row = "04-Test", 4, IF(Stage@row = "05-Launch", 5)))))

Then once you have a number associated with each Phase, you can map this in a Chart. I would add a separate Text widget to create your custom legend, explaining what each number represents:

See: Create a Chart for a Dashboard

Cheers,

Genevieve

Weinrich.Jason

Thank you @Genevieve P.! I appreciate the walk-through!

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.