MegaBill

Overview

A key aspect of FinOps is cost management, which involves tracking, identifying, and optimizing cloud spend and usage. With Finout's centralized dashboard, known as the MegaBill, you can easily visualize your entire cloud spend and usage data in one place, pinpointing areas for cost and usage reduction, and enabling informed decisions on budget allocation and future planning.

This approach aligns with the FinOps principle of financial governance, promoting collaboration between IT and finance teams to enhance visibility, accountability, and control of cloud costs. Furthermore, by gaining a clear understanding of your cloud usage and spending patterns over time, you can identify trends and continuously optimize your cloud usage, reducing costs and aligning with your business objectives. This reflects the principle of continuous optimization, an ongoing process of identifying, implementing, and measuring cost-saving opportunities and improvements.

Tracking Cost and Usage in Finout’s MegaBill

The MegaBill includes the option to toggle between both cost monitoring and usage tracking data views. This dual tracking capability empowers you to not only manage expenses but also understand how resources are being utilized.

For example, consider tracking the running hours of an EC2 family. As part of a savings plan with your cloud provider for that specific EC2 family, you receive a discount, but your usage remains constant. The value of seeing usage data lies in your ability to track how resources are utilized. This helps you maximize the benefits of your savings plan while ensuring efficient resource management.

Cost data in the MegaBill is available for all cloud providers and services supported by Finout. Usage data is available for AWS, GCP, and Azure. You can learn more about usage types in your data here.

Using MegaBill

By default, the MegaBill screen will display a graph and table of cost data for the cloud services and providers integrated with Finout.

You can use MegaBill by selecting filters, saving a desired filter (Create a View), or selecting an already saved set of filters (Saved View).

To drill down into your MegaBill, you can use the following filtering options:

1.Apply a Saved View

If you have already saved a set of filters. (Creating a view and a detailed description of a MegaBill filters detailed below)

1. Navigate to MegaBill.

   
2. Once a view is created (see #2), click Select view in MegaBill.

   
3. Choose a previously created view or a Finout Pre-defined view. The view is added to MegaBill and the graph and table are filtered accordingly.

   Note: You can select one or more filters to see a list of relevant views. For example, selecting AWS and GCP will show all saved views that include AWS and GCP resources or labels.

2.Create a New View

1. In Finout, navigate to MegaBill.

   
2. Select the desired filters to best fit the MegaBill view to your needs (filters are detailed below) and then click Save. The Save new view side-window appears.

   
3. Enter a View Name.

4. You can optionally enable ACL Permissions.

   • ACL permissions are disabled by default, meaning all users can view or edit based on their specific role or access. See Role-Based Access Control and ACL Permissions documentation for more information.
   • Optionally enable ACL permissions to define read and write and permissions on a financial plan for specific users and groups.

     Note: Enabling ACL on an object overrides user role permissions, except for admins.

   There are three modes with ACL permissions:

   • Public: Everyone in your organization has this permission to the object.

   • Private: Only admins have this permission to the object.

   • Shared: You must define users and/or groups.

5. Click Save. Your view is saved a appears under Select View.

3.Filters

Select the required cost center, for example, AWS, and select the required drill down, for example, services.

Advanced filters (Optional): Filter the view even further.

4.Time Aggregation

Daily, weekly, or monthly.

5.Report Period

6.Data Type

Select either cost or usage.

• Cost:

  • Choose the cost type.

    
• Usage:

  • Choose the unit type.

    

  • Choose a usage type.

  

7.Choose a Display

• Cost

• Cost Delta By using the delta graph, you can track cost or usage changes over time directly within the MegaBill. This visualization highlights differences between two points in time, helping to identify trends. For example, you can monitor month-over-month cloud spend variations or changes in resource consumption, such as CPU hours.

  How is it calculated? Each bar in the graph represents the change from the previous bar based on the selected interval. For example, if the costs are:

  • January: $20,000

  • February: $25,000

  • March: $35,000

  The graph will display:

  • February delta: $25,000 - $20,000 = $5,000

  • March delta: $35,000 - $25,000 = $10,000 For each selected interval, the bars represent the difference in cost compared to the previous period—daily compares to the previous day, weekly to the previous week, and so on.

    Note: - When using the Delta view, you won’t see the total cost, share of total cost, and average on top of the graph. - The X-Axis (date) cannot be changed.

• Trend Projection (Coming Soon) This layer enables users to generate future-oriented estimations based on past and current data trends. It utilizes selected time frames to provide projected trends, helping in strategic planning and decision-making. How is it calculated? The trend projection uses a linear forecast based on cost and usage data from the lookback period. It calculates the difference between the total cost on the last day with available data and the cost on the first day, then divides this by the number of days in the period. This result is then either accumulated over the projected period or displayed as an incremental daily change. ​

  1. Set Lookback period - Set the historical period for calculating projections.

     
  2. Set Projection Period - Set the timeframe for displaying projections.
  3. Set Trend Display Settings: Incremental or Cumulative Incremental - Represents the cost or usage for each individual period only (e.g., that day, week, or month), adding values from previous periods. Cumulative - Represents the total value accumulated up to that point. The Trend Projection layer is set.

8.X-Axis value

Select the value to be presented on the X-Axis.

9.Cost Type

Select a cost type. See Cost and Usage Types for a detailed explanation.

10.Group By

Select the desired grouping option.

Analyzing MegaBill's Data

Once your MegaBill view has been created, you are presented with a graph and table view of your chosen data.

MegaBill Graph

The following costs/usage data appears above the graph:

• Total cost or usage: The total cost or usage for the selected resources and period.

• Share of the total cost or usage: The selected filtered costs/usage as a percentage of the total MegaBill cost/usage.

• Average daily cost or usage: The average cost/usage per time interval (day/week/month) for the resources selected in the filters for the specified period.

  Note: The MegaBill graph view displays the top 30 daily cost values. Any additional values are grouped under "Others."

Note: You can quickly drill down into the costs/usage by clicking an area on the graph.

MegaBill Table

The following costs/usage data appears in the table:

• Total: The total cost/usage for all the selected resources and each resource for the current period (sorted from highest to lowest).

• Previous period cost/usage: The costs for the previous period. Values that have decreased appear in green, and values that have increased appear in red. An indication of the percentage increase or decrease in costs/usage appears.

• Percentage of cost/usage: The total cost/usage percentage.

  Note: The MegaBill table view displays the top 50 daily cost values. Any additional values are grouped under "Others."

Managing MegaBill

Manage your MegaBill by editing, viewing, deleting, downloading, or cloning data to maintain control and optimize costs.

1. Clear a View: Click the Clear View icon at the top of the MegaBill page. This will revert the MegaBill to the default setting.
2. Use a View as a Dashboard Widget: Add a view to a dashboard by selecting Add to Dashboard, providing a widget name, and choosing an existing dashboard or creating a new one.

   

   
3. Edit a View Name:

   1. In MegaBill, select the views dropdown on the top left of the page.

      
   2. Click the three dots and then choose Edit view. The setting side window appears.

      
   3. Edit the View Name.

   4. You can optionally enable ACL Permissions. See ACL Permission documentation or more information.

      • ACL permissions are disabled by default, meaning all users can view or edit based on their specific role or access. See Role-Based Access Control and ACL Permissions documentation for more information.
      • Optionally enable ACL permissions to define read and write and permissions on a financial plan for specific users and groups.

        Note: Enabling ACL on an object overrides user role permissions, except for admins.

      There are three modes with ACL permissions:

      • Public: Everyone in your organization has this permission to the object.

      • Private: Only admins have this permission to the object.

      • Shared: You must define users and/or groups.

   5. Click Save. Your view is saved.

4. Clone View:

   1. In MegaBill, select the views dropdown on the top left of the page.

   2. Click the three dots and then click Clone View. The view is copied.

      
   3. Edit the view as required.

   4. Click Save.

   Or alternatively...

   Create a view based on an existing one:

   1. In MegaBill, select the required view from the dropdown on the top left of the page.

   2. Update the view filters as required.

   3. Click Save.

      
   4. If you are creating a new view, enter a view name.

      
   5. Click Save View.

5. Copy the view ID:

   1. In MegaBill, select the views dropdown on the top left of the page.

   2. Click the three dots and then choose Copy view ID.

      
6. Delete a View:

   1. In MegaBill, select the views dropdown on the top left of the page.

   2. Click the three dots and then choose Delete view.

      

Note: Deleting a view will remove it for all users in the account.

1. Remove Recent View:

   1. In MegaBill, select the views dropdown on the top left of the page.

   2. Click the three dots and then choose Remove Recent view.

2. Download MegaBill Data: Download data from the graph or table in CSV format. ​ ​To download a CSV of the MegaBill graph:

   1. Navigate to MegaBill.

      
   2. Click . A CSV of the MegaBill graph is downloaded.

      Note: The MegaBill graph view displays the top 30 daily cost values. Any additional values are grouped under "Others."

   To download a CSV of the Megabill table with “Others” values:

   a. In MegaBill, scroll to the table section at the bottom of the screen.

   

   b. Click and then click Download more values to CSV.

   Note: The MegaBill table view displays the top 50 daily cost values. Any additional values are grouped under "Others." A downloaded CSV will have up to 1000 values.

3. Three Dots

   • Remove Costs by Date: In the table view, click the three dots and turn toggle the dates off.

     
   • Transpose Data: Toggle data transposition in the table view by clicking the three dots and turning Transpose on or off.

     

FAQs

Question: When there are too many data points on a stacked bar chart, how does FinOut handle them?

Answer: FinOut automatically groups the top values of the various views and the less significant values into the "Others" category.

• In the graph view: The top 30 cost values per day are presented, all other values are grouped as “others.”

• In the table view: The top 50 cost values per day are presented, all other values are grouped as “others.”

• Downloaded Data: The 1000 top cost values are presented, all other values are grouped as “others.”

Question: How does the "Others" category logic work?

Answer: The "Others" category is used when there are too many data points to display individually on the chart. The logic prioritizes displaying the most significant values separately by cost, while less significant values are grouped under "Others."

Question: Can I ungroup the "Others" category when exporting to CSV?

Answer: Yes, when exporting to CSV, you can ungroup the "Others" category so that data points are listed individually rather than being summarized under a single "Others" row. A downloaded CSV will have up to 10,000 values.