Is the 'while' function currently supported Metabase? When trying to run it, it doesn't appear to be supported.
For context, I'm trying to count the number of rows per month, where 2 dates inside the row sits either side of the month I'm iterating over.
To do this I am setting a new variable 'month' and want to run a while loop where I will count the number of rows where created_at and end_date are either side of 'month' then add an interval 1 month to 'month' and run again until 'month' is = date_trunc('month', current_date).
Any help would be much appreciated!