Advanced reporting data not matching with analytics data in Resource Mangement

subhadrav

We use the advanced reporting in Smartsheet Resource Management to pull realtime data into the Smartsheet dashboard. In the time and hours advanced report that we pull in, the data is repeating 5 times for 5 weeks of July, whereas the analytics in tool shows the data in one line for the month of July. Can we match the view of the analytics report

Advanced report.png

Analytics report.png

in the advanced report as well.? We did group by. Attached are two screen shots of how the same report is available in one line in the resource mgmt tool vs 5 lines in the advanced report and hence the 5 lines are showing in the dashboard which confuses people on why the monthly report is pulling in multiple lines