Need help creating graph - reports late

I need to create a graph, for two different people, tracking to see if reports are done on time or not. I need to use the assigned to column and then the days late column. Negative were done early, 0 were done on time (Day Of), and then positive numbers will be late.

Each graph would be just the one person, and then % completed on time/early, and then % completed late.

hopefully that provides enough information to help me create a formula for a dashboard!

Find more posts tagged with

Dashboards

graphs

Accepted answers

All comments

Leroy Noriega

You can filter by the current user, this will allow the user to only view what's under their name in the report.

As for the other columns, you can add / remove columns in the column tab in the ribbon.

Paul Newcome

On a separarte sheet…

[% Completed On Time/Early]

=COUNTIFS({Assigned To}, @cell = "John Smith", {Days Late}, @cell <= 0) / COUNTIFS({Assigned To}, @cell = "John Smith")

[% Completed Late]

=COUNTIFS({Assigned To}, @cell = "John Smith", {Days Late}, @cell > 0) / COUNTIFS({Assigned To}, @cell = "John Smith")

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.