Numeric Value ' ' is not recognized

Get Help
1

Hello. For some reason, I'm getting the below error any time I try to increase my date range to include historical data. I'm simply trying to do a sum of a numerical field by date and filtering out by a different numerical field.

39
391504×618 52.2 KB

My question works when I limit it to last 2 months, but if I increase it to 3+ months, I get that error. Would you know what this type of error suggests? To my knowledge, the historical data is not corrupted.

Any insight would be appreciated! Thanks.

2

Hi @mbadua
It sounds like your database is returning an empty string instead of null for something.
Try using days instead of months, since it will make it easier for you to find the culprit row.
You need to change that in your database - Metabase cannot change that.

3

Thanks! That did the trick.