Hi @Ian Cotterill
Thank you for being part of Apptio community. I do agree with you that getting a single metric reflecting a Public cloud consumption is not so obvious but not impossible. you can actually create your own Metric . Here you can find some guidance : Create custom Metric !
Regards
Abekan
#Cloudability