Counting prior month data

Kaitlyn Carroll

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!

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)

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!