Test reports ("why is record A not part of this report?")

Testing which records will be part of a list, or will enroll in a workflow is super helpful with troubleshooting.

The same could be helpful for reports, especially those with complex filters.

Quite often I’ll have a user ask ‘why isn’t my report showing X record?’.

This means having to go into the report, look at all the filters, and look at all the element of the record to work out which data is incorrect.

Just like the enrolment in workflows, I’d love to be able to find a record in the report view and have a visualisation which shows TRUE/FALSE against whether the criteria has been met.

For example, if there are 10 filters on the report, it would be able to tell me that 8 of the criteria is met, but the record isn’t showing because of the other two criterion.