What if my report is not pulling any data / I get an error that says “no data to report” when I run my report?
The most common cause of blank reports is that selection criteria for the report have been set too narrow for Prophet to find data that matches all the criteria set.
A good practice is to start with a wide data set with very few criteria, and run the report to make sure it is extracting data as you would anticipate. Then narrow the selection criteria as needed. When no data is presented, often times the date range is set too narrow or a particular filter eliminates the data you are actually searching for.
To verify what filters are in place, refer to the Sort Parameters and Filters section of the Report Manager.
Look within each tab (Date, Accounts, Revenue, and Criteria) to see which filters have been set.
Is the data range possibly filtering out the data you want?
Are you only filtering on specific contacts or companies?
Is the revenue range too specific?
Is there another criterion that was set?
Perhaps there are several filters in place and your data does not meet ALL filters set.
Start with no filters and then slowly add filters to ensure you don’t end up filtering out ALL the data.