Offset function not found

1

Hi there,

I'm looking to do a rolling 14-day % change over time graph. For that, i want to compare today's count with yesterday's count dynamically for the past 14 days.

I found the Offset function here but when I type it into the query builder, it doesn't work even with the sample database : https://www.metabase.com/docs/latest/questions/query-builder/expressions-list#offset

image

The database I intend to use this on has a Postgresql engine. Offset function not found

4

Hey @farhan, the offset function is available starting from Metabase version 50.

5

@AbedHabli it's part of this Time Series comparison guide and I thought it was already a part of the product. Period-over-period comparisons for time series

Would you be kind enough to let me know what the version 50 is planned to be released?

Thank you

6

Hi @farhan

Sorry for the late reply. We're planning to launch version 50 soon in the upcoming weeks. Please keep an eye out for updates.

Thanks!

7

Hello! I'm on version v0.52.4 and Offset function does not seem to exist. Using PSQL DB

8

what does PSQL DB means?

9

I agree, running Metabase v1.51.6 and offset function is not found.