Hello,
I'm having trouble with the date filter in a dashboard.
Here is my "question." As you can see, the query calculates the total revenue (sum of TotalPaid
) and the total bookings for the current year and last year. I'm using PostgreSQL as the database, and "CA Y-1" and "BOOKINGS Y-1" use the Offset
function.
- For "CA Y-1":
Offset(Sum([TotalPaid]), -364)
- For "BOOKINGS Y-1":
Offset(Count, -364)
As you can see, I get results, so it works.
If I add a date filter to the query, it works as well (see the next screen).
The problem arises when I add this "question" to the dashboard.
As you can observe, "CA Y-1" and "BOOKINGS Y-1" are empty, even though they were populated with a date filter in the "question" section.
I checked the logs and found this :
2025-01-10 14:45:42 2025-01-10 13:45:42,935 ERROR middleware.process-userland-query :: Error saving field usages
2025-01-10 14:45:42 clojure.lang.ExceptionInfo: Unknown type of ref {:ref [:sum {:lib/uuid "b6f20de0-3edb-4e19-b59f-28c00659ce28"} [:field {:base-type :type/Float, :lib/uuid "e458345f-b32b-4bd5-9edd-824c1ebf9c44"} "TotalPaid"]]}
2025-01-10 14:45:42 at metabase.lib.equality$find_matching_column31950__31953.invokeStatic(equality.cljc:308)
2025-01-10 14:45:42 at metabase.lib.equality$find_matching_column31950__31953.invoke(equality.cljc:264)
I do not understand the origin of the problem. Your help will be very much appreciated.
Best Regards,