Query result in Retool and in live DB do not match

A simple COUNT SQL query returns different results in Retool vs. when queried directly from the live DB. This issue then extends to any graphs which similarly seem to truncate after some arbitrary number of values (i.e. query to show data in bar graph from past 1 year shows data up to February, but there is data for March and April that is not shown).

Hi @jaytul which database are you using? Can you share screenshots of the SQL query in Retool and the same in another SQL client? (You can submit images through our chat support if sensitive data.)

@alex have contacted Chat Support, awaiting response, thanks