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
Best Answer
-
in my initial comment i indicated you have to create the column "month" on the dataset (not a beast mode).
in a similar way, you should put Month on the axis instead of using Date. if you need yearMonth, create the column yearMonth.
Alternatively, remove date from the axis and try adding it again. Domo's UI can be weird sometimes.
Jae Wilson
Check out my š„ Domo Training YouTube Channel šØāš»
**Say "Thanks" by clicking the ā¤ļø in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1
Answers
-
In your columns, change each of your fields except for date to aggregate by SUM. This will give you one row per month.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1 -
Domo broke / changed functionality in product.
lag(count(`ID`)) over( order by month (`Date`))
you have to add the month(`Date`) column as a real column in the dataset.
Also be careful, laging by month(date) will lag 12,11,10,9, 8 but won't lag with respect to the year.
Jae Wilson
Check out my š„ Domo Training YouTube Channel šØāš»
**Say "Thanks" by clicking the ā¤ļø in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"2 -
@MarkSnodgrass usually that works but now I already added "count" in my beastmode so I can't sum it. If I add it in beastmode it just crashes.
@jaeW_at_Onyx thanks that makes sense. Too bad it still doesn't work. I think it has something to do with my date field.
I removed all other columns and only added the "month" beastmode and my "date" field so you can see the actual values. If I remove the "date" field it will still show multiple entries per month. I can't figure out why that is.
And I am aware of the year, thanks for the headsup but I only use the current year :)
0 -
do you have Date in the Sort clause?
Jae Wilson
Check out my š„ Domo Training YouTube Channel šØāš»
**Say "Thanks" by clicking the ā¤ļø in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
No I don't
I added month(`Date`) and count(`ID`) as columns, that does group them by month. But when I add the lead beastmode lag(count(`ID`)) over( order by month (`Date`)) it gives me the same problem.
I can't figure it out as everything seem in order according to your video.
I might create a dummy dataset tomorrow to make sure nothing in my dataset is causing this for some reason.
0 -
Okay I created a dummy data set and it is giving me the same problems.
If I add the following beastmode as a column: lag(sum(`Quantity`)) over( order by month (`Date`)) the problem persists.
Attached you can see my data and my data preview. If I set "graph by" to "month" it doesn't make a difference.
If I remove "LAG" it does work fine so my guess is that something is missing in my beastmode. A group by month call or something. Sadly I'm still a novice so I have no idea how to make that workš
0 -
in my initial comment i indicated you have to create the column "month" on the dataset (not a beast mode).
in a similar way, you should put Month on the axis instead of using Date. if you need yearMonth, create the column yearMonth.
Alternatively, remove date from the axis and try adding it again. Domo's UI can be weird sometimes.
Jae Wilson
Check out my š„ Domo Training YouTube Channel šØāš»
**Say "Thanks" by clicking the ā¤ļø in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive