Troubleshoot – Pulse Dashboard
Problem #1: Date Ranges Aren’t The Same
If your date ranges aren’t the same across all sheets, you will eventually try to pull data in to your Dashboard and find it difficult.
There are 2 ways you might display data in a different sheet that makes sense in the context of that sheet, but creates problems on the dashboard.
Removing unused date columns
First, you might want to show only some dates for some data. You may only care about tracking blog posts per month, and not about the Last 7/Last 30/Last 90 days.
So you may be tempted on the Content sheet to show only the Month dates.
But now you’ve introduced a problem.
If you do pull the data from this sheet in to your dashboard, but then later decide you want to track some Recency stats on your Content sheet (like comments), you’ll have to create new columns on your Content sheet. And Google Sheets is pretty good about moving formulas around, but it’s better to not risk Google Sheets not recognizing that three columns were created on a different sheet and then displaying incorrect data.
Problem #2: Showing date by row
Sometimes you want to show date by row. It’s easier to read down a column of numbers than to read across.
While this makes your source sheet easier to read, it is now much harder to draw this data in to your Dashboard.
Don’t put your dates on rows anywhere in Pulse. (Or put your dates in rows everywhere in Pulse- just don’t mix the two approaches.)
I’ll post more troubleshooting tips here as I answer questions about this course.