Metrics not matching Dashboard

Hello,

I have a metrics sheet (as seen below)

The numbers in the last row are averages of the numbers above them. When I go into my Dashboard and I select the above metrics sheet to use for my 'Metric Widget' the averages do not match (as seen below) in 2 columns. I have saved and refreshed several times and I've also fully exited out of both the Metrics Sheet and the Dashboard a few times but for some reason, the averages in 2 of the columns still don't match.

any ideas about how I may be able to fix this?

Thank you,

Amelia P.

Find more posts tagged with

Accepted answers

Georgie

Hi @Amelia P.,

Have you tried deleting and recreating the formulas that are showing the incorrect values from the dashboard? I would attempt this, then save the sheet and then open the dashboard in the same browser tab.

If that doesn’t resolve the issue, the best next step would be to open a ticket with our Support team so they can take a look at this specific sheet and dashboard and communicate with you via private channels. If you open a ticket, please provide them with these screenshots as well as the IDs of the sheet and dashboard (open the item and click File > Properties to find the ID).

Thanks,

Georgie

All comments

Ray Lindstrom

Hi @Amelia P.,

Have you by chance made a copy of your workspace and/or files? If so, is there any chance you're pointing the Metric Widget at the incorrect copy?

Click Reject on this comment if it is not the solution, and your question will go back into the queue for others to examine.

Amelia P.

Hi there,

No, there are currently no copies :/

Ray Lindstrom

@Amelia P.,

Ok then, I'm stumped.

Please "reject" all comments, and your question will return to the "Unanswered Questions" queue for review by other community members.

All the best,
-Ray

Georgie

Hi @Amelia P.,

Thanks,

Georgie

Amelia P.

Sounds good, Georgie - Yes, I have tried the suggestion and now I'm waiting to see if it behaves the same way it was behaving the past couple of days but thank you for your help! I'll be sure to open that ticket if need be, thanks again!

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.