Discrepancies between query and dashboard results

[yuvala]

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?

[Alberto_Umana]

Hi @yuvala,

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

[yuvala]

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: