I am trying to create a table like the one in the image. Is it possible to get this done in metabase?
If anyone has done something similar, can you walk me through the process.
Thank you!
Hi @mazhar
You would have to create this in SQL, since it would require windowing (among other), which Metabase currently doesn't support via GUI questions.
If I were to create this in SQL, what should be my query like.
For instance I have a table with columns order_date, first_time_orders, repeat_orders
and I have to calculate Month on Month percentage of repeat orders like the table shown in the image.
What will the query be like. If you could please walk me through it.
@mazhar That would depend on your database type. I would recommend that you try searching in a forum dedicated to your database type or stackoverflow.com