Chart on Project Tracking Dashboard.

Hello Everyone,

Am trying to show stock allocation on project tracking dashboard and when I select all columns from stock allocation sheet it's only showing one column.
How can I have a chart on project tracking dashboard showing all retailers including Allocation, Ordered and Balance columns.

Also, is it possible to have box or at least bottom line in each box.

Please see below picture what am trying to achieve.

Thanks in advance,

Find more posts tagged with

Dashboards

Accepted answers

AravindGP

Hi @Saj

When selecting the chart type, ensure to toggle your Switch rows & columns to get all retailers and the values in your helper column (allocation, ordered, balance).

You can't get a table in a chart. What you will need for that is to create a report and summarize the values in the summarize section of the report. Based on your image, if you want it to be similar, you will need to have retailers as rows and allocation, ordered, balance to be columns in your sheet.

All comments

AravindGP

Hi @Saj

When selecting the chart type, ensure to toggle your Switch rows & columns to get all retailers and the values in your helper column (allocation, ordered, balance).

Saj

Hi @AravindGP, Thank you for explaining and after adding report / summary. I was able to get my chart on project tracking dashboard.

Appreciate your support. 😀

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.