I would add a calculated field with the expression:
resource_view.usage_quantity/24
Then do something along the lines of:
Use the calculated field for value (sum)
Use usage_date (Month) for x axis
For Group/Color use instance_type_family
You can avoid the division by (24*{days in month}) this way.