Count Mismatch in Scorecard and Table Charts with Same Filters in Looker Studio

[Mohanrao]

Hello everyone, 

I'm facing an issue in Looker Studio where the count of records in my Scorecard widget does not match the count in my Table chart, even though I have applied the same filters on both. Here’s what I’m dealing with: 

The Setup: 

• I am using Looker Studio to create a report showing participant data. 
• I have a Scorecard that displays the count of unique participants, and a Table chart that shows the detailed participant records. 
• To identify unique participants, I’m using a concatenation of first_name, last_name, and dob as a unique identifier. 
• The filter conditions applied are: 

region = 'Central' 

age BETWEEN 5 AND 11 

program_portfolio = 'Ismaili Civic' 

The Formula I’m Using: 

I’m counting unique participants using this formula: 

COUNT_DISTINCT( 
 IF( 
   region = 'Central'  
   AND age BETWEEN 5 AND 11  
   AND program_portfolio = 'Ismaili Civic',  
   CONCAT(first_name, last_name, dob),  
   NULL 
 ) 
) 

The Problem: 

• The Scorecard count and the Table chart count do not match, even though the same filters and fields are applied to both. 
• I expect the counts to match because they both use the same criteria for identifying unique participants via the concatenated first_name, last_name, and dob. 

What I’ve Tried: 

• Refreshed the data source in Looker Studio. 
• Checked the date range picker to ensure it’s the same across the report. 
• Switched the Scorecard to a Table chart to ensure consistency with the data. 
• Ensured that the correct date field is selected in the settings tab of both widgets. 

   

  Additional Information:

  I noticed that when I add the date range control, the Scorecard count doesn’t work correctly. However, if I remove the date range control, the counts match. This suggests there is an issue with the connection between the date range control and the Scorecard count, specifically when using the COUNT_DISTINCT function with the concatenated fields.

Here is the related screenshot:

My Question: 

Why is there a discrepancy in the counts between the Scorecard and Table chart, even though both are using the same filters and formula for identifying unique participants? Is there a known issue with how COUNT_DISTINCT works with concatenated fields like first_name, last_name, and dob? 

Any insights or suggestions would be greatly appreciated. Thanks in advance!