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
- 10.7K All Categories
- 13 Getting Started in the Community
- 41 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.5K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 303 Use Cases & Best Practices
- 503 APIs
- 121 Apps
- 48 News
- 754 Onboarding
- 1.2K 日本支部
- Private Company Board