Basic cost calculation method
This is a method of analyzing costs by utilizing each field when analyzing costs using Tableau.
1. Analyze the costs of AWS and Azure
How to analyze costs for AWS and Azure.
AWS provides cost data in USD by default. Azure provides the currency unit in KRW.
In Tableau, if you place the csp field on rows and the Currency field on columns, you can see what values exist.
By default, AWS lets you find out your cost by simply adding up the Cost fields.
If you place the Company Name field in the rows and Usage Month in the columns, you can see how the Company*Month is entered.
In this state, position the csp field by dragging and dropping it to the right of the Company Name in the row.
By positioning it like this, you can check the monthly data distribution by Csp within the company. (The value indicated as ABC means that there is a data row for the combination of rows and columns.)
In this state, find the Cost field and drag and drop it onto the text among the five squares in the mark area.
Then, the sum of the Cost field is calculated in the place where it was written as Abc, as follows.
In this state, if you find the Currency field on the left again and drag and drop it to the right of Csp in the row, you can see the result below.
2. GCP
For GCP, unlike the above, you need to calculate it by adding the field called [Credits Amount Disc] to the Cost field.
For AWS and Azure, there is no value for Credits Amount Disc, so regardless of CSP, calculating by adding the Cost field and Credits Amount Disc field will not be calculated properly.
* For AWS and Azure, the Credits Amount Disc value is "no value" and not 0, so simple summation does not work.
First, to create a new field calculated from the two fields, click Analysis > Create Calculated Field at the top.
In the pop-up that appears, first name the new field at the top, then enter the formula as follows and click the OK button.
Formula: [Cost] + IFNULL([Credits Amount Disc], 0)
After the pop-up closes, if you search for the name of the field you created on the left, you can see that the field has been added.
Drag and drop this field as shown below.
Then, you can check the changed GCP costs as below.
For further inquiries, cmpadmin.cloudxper@lgcns.com Please email us at ,
Technical Support Center Please log in and leave your inquiry and we will respond.