Current user metric widget

I have an evaluation form that gets filled out and results can be viewed on a dashboard. I have two, one for the submitter to see only their entries and one for the location being evaluated and the viewers see only the evaluations that are pertinent to them.

I have a sheet summary formula that counts the total visits and displays on the dashboard as a metric, but I only know how to count the total visits. Is there a way for this metric to show current user total only?

Find more posts tagged with

Metric Widget

current user

Accepted answers

Edit Kalb

I ended up using dynamic view and that allowed me to show current user view from a published dashboard.

All comments

Erin Horiuchi Green

Hello @Edit Kalb ,

Have you tried Generate a Sheet Access Report in the Admin Center?

Must be on a Business or Enterprise plan and a System Admin to setup.

Edit Kalb

Thanks Erin. I'm on an Enterprise plan but not a System Admin. What I am hoping is for widgets like this:

which pulls from a sheet summary on the source sheet:

I would like for the dashboard widgets to show current user counts if possible.

Edit Kalb

As I'm re-reading this I'm realizing the dashboard is published therefore won't know who current user is!

Edit Kalb

I ended up using dynamic view and that allowed me to show current user view from a published dashboard.

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.