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
- 7.3K All Categories
- 13 Getting Started in the Community
- 141 Beastmode & Analytics
- 1.8K Data Platform & Data Science
- 54 Domo Everywhere
- 2K Charting
- 1K Ideas Exchange
- 903 Connectors
- 236 Workbench
- 342 APIs
- 77 Apps
- 19 Governance & Productivity
- 235 Use Cases & Best Practices
- 50 News
- 473 Onboarding
- 573 日本支部