함수에는 특정 유형의 인수를 사용해야 합니다. 인수의 형식이 일치하지 않으면 오류가 발생할 수 있습니다. 예를 들어 텍스트 측정기준에서 날짜 함수를 사용하려고 하면 함수 인수 유형이 일치하지 않게 됩니다.
올바른 입력 값을 선택합니다. CAST() 를 사용하여 입력 값 유형을 변경할 수도 있습니다.
측정항목 재집계는 지원되지 않습니다.
이미 집계된 데이터에는 집계 함수를 적용할 수 없습니다. 여기에는 Google 애널리틱스와 Google Ads에서 제공되는 대부분의 측정항목이 포함됩니다. 예를 들어 Sessions 는 이미 데이터 세트에서 합계로 집계되었으므로 SUM( Sessions ) 수식을 사용하면 오류가 발생합니다.
이 같은 제한은 기본 데이터 세트에서 비롯된 것입니다. 가능한 경우 데이터가 표시되는 방식을 변경해야 합니다.
표현식에는 측정항목 또는 측정기준 하나만 사용할 수 있으며 두 개를 동시에 사용할 수는 없습니다.
함수 인수에 측정기준과 측정항목을 혼합해서는 안 됩니다.
데이터에 적절한 함수를 사용하고 있는지 확인합니다. 예를 들어 +를 사용하는 대신 CONCAT() 함수를 사용하여 텍스트 필드에 텍스트를 추가합니다.
[[["이해하기 쉬움","easyToUnderstand","thumb-up"],["문제가 해결됨","solvedMyProblem","thumb-up"],["기타","otherUp","thumb-up"]],[["이해하기 어려움","hardToUnderstand","thumb-down"],["잘못된 정보 또는 샘플 코드","incorrectInformationOrSampleCode","thumb-down"],["필요한 정보/샘플이 없음","missingTheInformationSamplesINeed","thumb-down"],["번역 문제","translationIssue","thumb-down"],["기타","otherDown","thumb-down"]],["최종 업데이트: 2025-07-31(UTC)"],[],[],null,["# Add, edit, and troubleshoot calculated fields\n\nThis page guides you through the following processes:\n\n- [Create a calculated field in your data source](#create-a-calculated-field-in-your-data-source)\n- [Edit a calculated field in your data source](#edit-a-calculated-field-in-your-data-source)\n- [Create a chart-specific calculated field](#create-a-chart-specific-calculated-field)\n- [Edit a chart-specific calculated field](#edit-a-chart-specific-calculated-field)\n- [Reuse a chart-specific calculated field](#reuse-a-chart-specific-calculated-field)\n- [Troubleshoot calculated fields](#troubleshoot-calculated-fields)\n- [Related resources](#related-resources)\n\nCreate a calculated field in your data source\n---------------------------------------------\n\n| **Note:** You must have edit rights to the data source to create and edit calculated fields.\n\nCalculated fields in data sources are available in any report that uses that data source. To create a calculated field, follow these steps:\n\n1. [Edit the data source](/looker/docs/studio/edit-a-data-source).\n2. Click **ADD A FIELD**.\n3. Select **Add calculated field.**\n4. Enter a **Name** value for this field:\n 1. This is the default name that appears in your reports. You can change this for individual charts by editing the name in the dimension and metric picker.\n 2. The field name must be unique.\n 3. You can't use a reserved keyword as the field name.\n5. Enter a value for **Formula** :\n\n 1. To select a dimension, metric, or function, start typing its name.\n 1. If you have multiple fields with similar names, or fields that duplicate part of a function name, for example, **Date** and **Date2**, type part of the name, and then scroll through the list and select the field that you want.\n 2. You can also click a field in the **Available Fields** list to add it to the formula editor.\n 2. On the bottom right, click **SAVE** (or **UPDATE** if you are editing an existing field).\n 3. Adjust the **Type** , **Aggregation** , and **Show As** options, as appropriate.\n\n Alternatively, you can create a calculated field in your data source from a report by following these steps:\n6. Create or [edit your report](/looker/docs/studio/edit-a-report).\n\n7. Click **Add a field**.\n\n8. Select **Add calculated field.**\n\n9. Enter a **Name** value for this field:\n\n 1. This is the default name that appears in your reports. You can change this for individual charts by editing the name in the dimension and metric picker.\n 2. The field name must be unique.\n 3. You can't use a reserved keyword as the field name.\n10. Enter a value for **Formula** :\n\n 1. To select a dimension, metric, or function, start typing its name.\n 1. If you have multiple fields with similar names, or fields that duplicate part of a function name, for example, **Date** and **Date2**, type part of the name, and then scroll through the list and select the field that you want.\n 2. You can also click a field in the **Available Fields** list to add it to the formula editor.\n 2. On the bottom right, click **SAVE** (or **UPDATE** if you are editing an existing field).\n 3. Adjust the **Type** , **Aggregation** , and **Show As** options, as appropriate.\n\n\u003e Learn more about [what you can do with calculated fields](/looker/docs/studio/about-calculated-fields) and the difference between calculated fields that are [created in a data source versus chart-specific calculated fields](https://support-con/looker-studio/answer/6299685#data-source-vs-chart-specific-calculated-fields).\n\nEdit a calculated field in your data source\n-------------------------------------------\n\nCalculated fields appear in the data source with an **fx** symbol. To edit the formula, click **fx** next to the field name. This opens the formula editor, where you can adjust the field as needed.\n\nCreate a chart-specific calculated field\n----------------------------------------\n\nChart-specific calculated fields exist only in the chart in which you create them.\n\nTo create a chart-specific calculated field, follow these steps:\n\n1. Create or [edit your report](/looker/docs/studio/edit-a-report).\n\n2. [Add a new chart](/looker/docs/studio/add-charts-and-controls-to-your-report) or select an existing chart.\n\n3. In the **Setup** tab of the **Properties** panel, click **+ Add dimension** or **+** **Add metric**, depending on the kind of calculated field that you want to create.\n\n4. Click **+** **ADD FIELD**.\n\n5. Enter a field name.\n\n6. Enter your formula.\n\n \u003e You can use the same operators and functions as data source calculated fields. However, you can't reference other chart-specific calculated fields. You can use chart-specific calculated fields with [blended data](/looker/docs/studio/how-blends-work-in-looker-studio).\n7. Click **APPLY**.\n\n8. Adjust the **Type** , **Aggregation** , [**Display Format,**](/looker/docs/studio/format-fields-in-reports) and **Show As** options, as appropriate.\n\n| **Important:** Custom value formatting is chart-specific and cannot be applied when creating or editing calculated fields in your data source.\n\nEdit a chart-specific calculated field\n--------------------------------------\n\nChart-specific calculated fields appear in the **Setup** tab of the chart's **Properties** panel.\n\nWhen you hover your cursor over the field type next to the field name, an **fx** symbol will appear. To edit the formula, click **fx.** This brings up the formula editor, where you can adjust the field as needed.\n\nReuse a chart-specific calculated field\n---------------------------------------\n\nChart-specific calculated fields only exist in the chart in which you create them. You can't directly reuse chart-specific calculated field, or reference it in other calculated fields.\n\nHowever, you can copy a chart containing chart-specific calculated fields. The copy will contain any calculated fields defined in the original. You can then edit them as needed in the new chart.\n\nTroubleshoot calculated fields\n------------------------------\n\nIf there is an error in a calculated field formula, you'll see a warning message, and you won't be able to save the field. Here are a few reasons why a formula might be rejected:\n\nRelated resources\n-----------------\n\n- [Dimensions and metrics](/looker/docs/studio/model-your-data)\n- [Format fields in reports](/looker/docs/studio/format-fields-in-reports)\n- [Create a data source](/looker/docs/studio/add-data-to-a-report)\n- [About calculated fields](/looker/docs/studio/about-calculated-fields)\n- [Create a custom group](/looker/docs/studio/create-a-custom-group)\n- [Create a custom bin](/looker/docs/studio/create-a-custom-bin)"]]
필드 추가를 클릭합니다.