Quicksight Dashboard for EC2 count

To create a dashboard in Amazon QuickSight that displays the account name, region, and total count of EC2 instances, you can follow these steps:

1. Access the Amazon QuickSight console and create a new analysis.
2. Add a new data source by connecting to your AWS account. You can choose to connect to an Amazon EC2 data source directly or use Amazon Athena to query the EC2 instance data.
3. Create a dataset that includes the following fields:

Account Name Region EC2 Instance Count You can use the COUNT() function in QuickSight to get the total count of EC2 instances per region.

4. In the QuickSight visual builder, create a new visual and select the appropriate visual type (e.g., table, bar chart) to display the account name, region, and EC2 instance count.

5. Customize the visual by adjusting the field settings, formatting, and layout to suit your dashboard requirements.

6. Save the visual as a new dashboard or add it to an existing dashboard.

7. To retrieve the EC2 instance count data, you have a few options:

a. Direct EC2 Data Source: Connect directly to the EC2 service in QuickSight and use the COUNT() function to get the instance count per region.

b. Amazon Athena Data Source: Use Athena to query the EC2 instance data from CloudWatch or AWS Config, and then connect the Athena dataset to QuickSight.

c. Custom SQL Query: Create a custom SQL query that retrieves the account name, region, and EC2 instance count, and use that as the data source in QuickSight.