Yes, this can be done.
Please create the following Business View Report : Test Execution Status By Type
For configuration, please set up the following:
For Business View, select Test Instances with Linked Runs
For X-axis, select Test Instance Status
For Y-axis, select Count Distinct and Linked Run Exec Date
For Grouped By, select Test Type
For a filter select Linked Run Exec Date =[Today] or =[Yesterday]
Obviously, select your current Project and Domain.
This should give you the results you are looking for.
I hope this helps.