Is there a way to create a dashboard that will update weekly?

Jessiec1989

Right now I am sending out a weekly report, but am using excel and pivot tables. Some of the info on the report is YTD which is easy to set up, but other tables are only from the past week. Is there a way to set up graphs/tables that would update M-F weekly on their own? I don't want to pull from the last 7 days as that could use parts of different weeks. It's probably not possible, but wondering if there is a way to set it up where on Monday it would only show Monday, Tuesday would show Monday and Tuesday, so on and then reset the next week. I know I'm asking a lot :)

Find more posts tagged with

Dashboards

DataTable

first day of week

graphs

Accepted answers

All comments

NickStaffordPM

Hey! So dashboards are inherently live, which means if you set your formulas up to have Monday, Tuesday, Wednesday, etc.. buckets for data, it should auto update as the base sheet information is updated.

The "reset" the next week thing you mentioned will have to do with your formula for the underlying metric and not the dashboard itself if this makes sense.

Do you have any additional questions or any clarification required?

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.