---
schema_version: "1"
id: 8b24037b45a22e61fb70b139980a083840d7241bd44034972409e20b43881344
title: Troubleshoot Unexpected Query Results
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_dashboards_steps_troubleshooting.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_dashboards_steps_troubleshooting.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 31ac6cdb88266161c67cd73f0b9532f133c27f4cb6aa74ca3f075eeee64ce395
description: If you have questions about a query’s results, review the query details to learn how CRM Analytics determines the results. Compare the original query to the final query executed by CRM Analytics. If the query is faceted or the dashboard contains global filters, CRM Analytics applies extra filters to query. If the query contains a binding, use the bindings tracer to verify the binding results.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# Troubleshoot Unexpected Query Results

If you have questions about a query’s results, review the query details to learn how CRM Analytics determines the results. Compare the original query to the final query executed by CRM Analytics. If the query is faceted or the dashboard contains global filters, CRM Analytics applies extra filters to query. If the query contains a binding, use the bindings tracer to verify the binding results.

1. Open the dashboard in view mode.
2. Click the drop-down arrow for the widget that uses the query that you want to analyze.
    
    ![Show Details button](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_dashboards_show_details_button.png)
3. Select **Show Details** for the widget.
    
    ![Tip](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/images/icon_tip.png)
    
    Tip To see the Show Details option for a list widget, enable the “Show explore action” widget property. The Show Details option doesn’t show for link, image, container, global filter panel, and text widget types because they don’t have queries.
    
    ![The step details shows information about the query as well as other factors that contribute to the total time required to populate the results of a step.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_dashboards_step_details.png)
4. To compare the original query against the final one, click ![View Query Details button](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_dashboards_View_Query_Details_button.png).
    
    CRM Analytics modifies queries based on interactions with other widgets. It adds filters based on faceting and global filters, and can modify the query based on bindings. The final query in the following example has three filters added to the original query.
    
    ![The final query has 3 additional filters not included in the original query.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_dashboards_query_details.png)
5. If the query has a binding, review the bindings trace to understand how CRM Analytics resolves the binding.
    
    ![If applicable, the query details shows the bindings trace.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_dashboards_bindings_trace.png)
    
    The easiest way to understand the bindings trace is to start from the bottom. In this example, you can see the results of both `cell` binding functions. You can also see that the `coalesce` function uses the results from the second `cell` function. The final result of the entire binding, which appears at the top, shows 5.