Counting prior month data

Hello,

I'm trying to report on prior month data points within a Dashboard I created. I've built a metric sheet off a "master" sheet.

I've attached a screen shot of the metric sheet and a screen shot of the master sheet columns.

Here is the formula I've been using to capture metrics - it needs to be changed to capture prior month not current month data.

=COUNTIFS({Sentiment}, "Positive", {Month}, MONTH(TODAY()))

=COUNTIFS({Region}, Metric@row, {Month}, MONTH(TODAY()))

*Range1 and criterion1 change based on the specific data I'm collecting.

Master sheet columns.PNG

Metric Sheet.PNG

The graphs in the dashboard are being fed by the metric sheet.

Any help is greatly appreciated. Thanks!

Find more posts tagged with

Formulas

Accepted answers

Mike TV

@Kaitlyn Carroll

You just need to add a -1. I believe this is the correct position to place it:

=COUNTIFS({Sentiment}, "Positive", {Month}, MONTH(TODAY())-1)

All comments

Mike TV

@Kaitlyn Carroll

You just need to add a -1. I believe this is the correct position to place it:

=COUNTIFS({Sentiment}, "Positive", {Month}, MONTH(TODAY())-1)

Kaitlyn Carroll

Awesome. Thank you so much!

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.