Wrong Event count

[Tobiazs]

Hi,

I have two data sources, one is GA4 events coming from BigQuery and the other is my Postgres Users table. I have a blend of these two sources, and when I try to get the all-time event count for a specific event I get different results. I noticed that when there is no Event Time dimension in blend the event count will be higher and correct than when it is present in blend data. 
To check the correct Event count I ran a simple query in BigQuery.

SELECT event_name, COUNT(*) AS event_count FROM `dataset`
WHERE event_name IN ('connect', 'start_session', 'save_session', 'delete_session','stop_session', 'send_workout', 'update','start_training', 'save_training', 'delete_training','stop_training', 'start_workout')
GROUP BY event_name ORDER BY event_count DESC

Below, you can see the difference in the Event count and how I joined these two data sources. 

Without Event Time dimension:

With Event Time dimension:

[marcwo]

Hi @Tobiazs 

did you check your report settings page and see if a default date range might be affecting your query results?

Thanks
Marc

[Tobiazs]

Hi Marc,

In both cases the date range is set to custom: This year. 
In report settings the default date range for this data source is set to auto.

[marcwo]

So, not sure I understand correctly, but with the query you are giving for the correct event count, you are counting everything without constraining by event_time - for the charts though, you are constraining to This year. I would assume that its expected to receive different results then because it is affecting your query?

[Tobiazs]

No, in the query I am also looking only at This year. Sorry for the misunderstanding.