Total number of EC2 instances

Question & Answer
,
1

Using the resource_view dataset provided by AWS, in the CUDOS production dashboard, I’m trying to create a visual that has the instance family and number of instances over the usage period.

If I use AWS Cost Explorer, I can derive this by taking the total hours/(24days in the month)
Example (1486.774723 EC2 running hours/(2431)) = 1.998353122 Instances for the month of March

How can I accomplish this given the fields available to me? Any AWS Cost Intelligence Dashboard folks have a solution for this?

2

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.

1 Like
3

Hi @usmitra,
It’s been awhile since we last heard from you, did you have any additional questions regarding your initial post?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

4

Hi @usmitra,
Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!