As you can see my data table groups by month which is want to achieve and my preview doesn't.
I've no filters or any sorting. I am probably overlooking something simple but I tried following Onyx' his tutorial (https://www.youtube.com/watch?v=cnc6gMKZ9R8) about window functions but I can't seem to group by month.
Should I add anything to my beastmodes?
For example I am using "count" instead of "sum":
lag(count(`ID`)) over( order by month (`Date`))
But I don't understand why the data table is showing me the correct way.
Thanks in advance and if you have any questions please let me know