# Total number of EC2 instances

**URL:** <https://community.amazonquick.com/t/total-number-of-ec2-instances/45343>\
**Category:** Q&A\
**Tags:** calculations, Business-Intelligence-Engineer, quick-sight\
**Created:** [April 23, 2025, 8:13pm UTC](https://community.amazonquick.com/t/total-number-of-ec2-instances/45343 "2025-04-23T20:13:45Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![usmitra](https://avatars.discourse-cdn.com/v4/letter/u/c57346/32.png) [@usmitra](https://community.amazonquick.com/u/usmitra)\
**Post date:** [April 23, 2025, 8:13pm UTC](https://community.amazonquick.com/t/total-number-of-ec2-instances/45343/1 "2025-04-23T20:13:45Z")

</div>

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/(24_days in the month)  
Example (1486.774723 EC2 running hours/(24_31)) = 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?

---

<div class="post-metadata">

**Author:** ![csoderlund](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/csoderlund/32/30096_2.png) [@csoderlund](https://community.amazonquick.com/u/csoderlund)\
**Post date:** [April 23, 2025, 10:00pm UTC](https://community.amazonquick.com/t/total-number-of-ec2-instances/45343/2 "2025-04-23T22:00:53Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Brett](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/brett/32/36494_2.png) [@Brett](https://community.amazonquick.com/u/Brett)\
**Post date:** [May 6, 2025, 7:13pm UTC](https://community.amazonquick.com/t/total-number-of-ec2-instances/45343/3 "2025-05-06T19:13:16Z")

</div>

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!

---

<div class="post-metadata">

**Author:** ![Brett](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/brett/32/36494_2.png) [@Brett](https://community.amazonquick.com/u/Brett)\
**Post date:** [May 9, 2025, 6:53pm UTC](https://community.amazonquick.com/t/total-number-of-ec2-instances/45343/4 "2025-05-09T18:53:45Z")

</div>

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!