---
schema_version: "1"
id: a325f2362d8661d06854e294e8d33646221fae298945ae9230963f941a4ef838
title: Query Editor Considerations
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_dashboard_step_saql_considerations.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_dashboard_step_saql_considerations.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 9fc496dbac9083499d7a93485e7cc5d79936e55ea3dd022381906b333969b02e
description: Keep these considerations in mind when switching to the Query Editor to update a query.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# Query Editor Considerations

Keep these considerations in mind when switching to the Query Editor to update a query.

- Column Names, Hidden Columns, Column Formatting, and Conditional Formatting:
    - Column enhancements that are done in the CRM Analytics interface aren't preserved when you switch to the Query Editor and must be reapplied. Examples include customizing column names, hiding redundant columns, formatting numeric columns, and conditional formatting based on a query.
- Projected Field Names and Subtotals
    - If you change a projected field name within the Query Editor, ensure that its corresponding projected subtotal field name is updated to match. Consistency between projected field names and their subtotal field names is crucial for accurate data representation and calculations.

![Example](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/images/icon_example.png)

Example In this example, Customer\_Name is updated to project Name. As a result, the Subtotal column name is dropped because it can't find Customer\_Name.

![SAQL query with unmatched projected column names.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_dashboard_step_saql_considerations_2.png)

Update the corresponding projected subtotal field name to match.

![SAQL query with unmatched projected column names.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_dashboard_step_saql_considerations.png)