Difference between preview and data table
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