topic Re: Discrepancies between query and dashboard results in Warehousing & Analytics

Discrepancies between query and dashboard results

yuvala — Mon, 24 Feb 2025 11:18:24 GMT

Hey all,

I have encountered a strange issue while validating my dashboard visual against the source table.

The visual shows the count(distinct VAL) per day and when I ran a query that does the same calculation I get a difference of 84 (on average) and the query result is always larger than the dashboard's result, could this be some sort of rounding error? as the results are in ~80K per day.

The filed the count(distinct) is calculated over is an int type and I have refreshed the data via the refresh button prior to the validation.

for example, here is the result from the query:

while for the same date in the dashboard I got this number:

What could cause these discrepancies?

Re: Discrepancies between query and dashboard results

Alberto_Umana — Mon, 24 Feb 2025 12:41:11 GMT

Hi @yuvala,

Are you using same query for the dashboard? could you please share it?

Re: Discrepancies between query and dashboard results

yuvala — Mon, 24 Feb 2025 12:45:56 GMT

Hey @Alberto_Umana,

for the dashboard I use

select * from bi_models.models.ve_daily_ads_agg

and then in the visualization y axis configuration I use the following this: