Hello!
I could be wrong, but I think I found a bug.
I would like to use a date table from my database, but I cannot use all the date functions that Metabase has if I make the relationship with the date.
With TREND especially, it does not understand the relationship with dates and does not allow comparisons to be made.
Obviously, there are other ways to relate date tables. For now, we will relate by a timestamp column.
Another issue is that Metabase could use our date table to use time filters, as this way we could have control and still have support from the application's native filter.
BR,