This article will explain what the report doctor does and how it works, so you can add validation checks to new sections you may have built within a customised report template. We will also show an example.
If you have further queries, please send us a question.
How Report Doctor Works
The Report Doctor is a tab within Excel which runs validation checks to find any possible issues on your reports.
Why add validations in Report Doctor?Sometimes services we gather data from may make changes, for example when Google Analytics changed how they track mobile operating systems.
This would cause reports to miss behave, and could create cells with missing data.
So, creating a validation tab will help check metrics and flag up any issues.
If you're creating your own Custom Reports in Excel, it's worth adding a Report Doctor tab to run some checks.
How to add validations in Report Doctor
We'll soon document some examples of validations, in the mean time if you have any specific queries, please do ask us a question.