If I want to report on revenue, which is a money field type, Metabase runs incorrect queries which result in errors.
For example, if I want to filter where money is greater than a certain amount, I get this error: “ERROR: operator does not exist: money > integer”
If I want to get a sum of the revenue, I get this error: “Bad value for type double”
It seems that Metabase won’t work with the money data type at all and there is also no way to cast the values. Is there a solution for this?