How can the Count of 'Reports With Dashboard' be greater than the 'Total Count of Reports'? Am I misinterpreting the data?
When I ran the following query in Workbench I got the count as 132435
SELECT count() FROM Report
The Report 'All Reports' , 'Created Date All Time' gave the same count i.e. 132435
Next I wanted to find how many of these 132435 reports are on a Dashboard.
For that, I created a report based on the ReportType 'Report With or Without Dashboards'
Report created is as follows -
Filters: Show Me = All reports Created Date = All Time
Included columns ‘Report Name’, ‘Last Run’, 'Dashboard Title'
Sorted the report by Title ascending to separate the reports that are not attached to dashboards.
After running the Report and exporting to excel -
Total count of rows in the excel file 193,840
Why is the count from 'Reports with Dashboards' is so much higher than the count of Reports obtained from the report 'All Reports Created All Time'?
The Count of Reports With Dashboards = 137338
I am wondering how is the Count of Reports with Dashboards greater than the total number of Dashboards?