I'd like to create a report in the Azure portal that will cumulatively show the following information:
Column names:
DB account
Collection name
Provisioned RU Throughput
RUs price per hour
Monthly cost
Rows must contain values.
Totals should be displayed for column 5 .
Default order by DB column 1 ASC.
I've found standard representation on the CosmosDB account's overview tab. Monthly cost column is missing there.
The solution with calculated monthly costs suits me. For example:
DB account Coll. name Prov RU Throug RUs price per hour Monthly cost
db houses 5000 $0.00012/RU 0.00012*5000*24*30=432
Column 'RUs price per hour' could be hardcoded.
I'd appreciate it very much if somebody could share any thoughts on how I can get this report.
I'd like to place it into a workbook or dashboard.
Thank you.