Row based table calculations

Get Help
1

Hi!

I have a table in Metabase that shows number of reservations by week. I'd like to add a calculated expression that compares each row to the row previous. In other words, I'd like to show the growth of each row compared to the row before.

I've mocked up an example below. Is this possible in Metabase right now? Week over week growth is very important to my business, so I need to be able to add a field like this! Thanks in advance for your help.

image
image814×312 49 KB

2

Hi @mvtemple
You would have to do such calculations in SQL. It's currently not possible to do in the Metabase GUI.

3

@flamber Ah, bummer! Thank you. I hope that gets added in the future - it would be so nice to be able to do Excel-like functions with offsets / lead / lag, etc. Appreciate the response.