Can someone help me with the syntax?
I am not sure why i am having such a hard time with this one but my brain is not putting the logic together very well.
I'm trying to create a calculated field where we are adding the total loan counts from 1st and 2nd mortages by date. Right now we have them split. I have been trying a fixed by function but I am not sure how to write the syntax for a group by date on this one.
Again, probably not too hard so TIA
If this helps, feel free to agree, accept or awesome it!
Answers
-
Hi @damen ,
So you really can't do this because SQL can only look at numbers on the same row. So you'd have to remove that First Mortgage column for your Loan Count Column to finally sum.
I actually just did this for another Domo user: https://www.youtube.com/watch?v=_ihXoDKAeag&list=PLLbgJInsMl7o3pPpLmyVe1AsxwX2OEJGO&index=6
If you REALLY WANT the mortgage amounts to be broken out by mortgage count, you'd need to do that in the group by. You'd have to select date and then sum Monthly Total and Loan counts in the group by.
Anyway, here's a video I made to help you follow along and answer your specific question. Hope it helps: https://www.loom.com/share/a6cf56d544f648bdba296029adb200d8
John Le
More videos at: https://www.dashboarddudes.com/pantry
John Le
You're only one dashboard away.
Click here for more video solutions:
1 -
@MichelleH sum(sum(`loan count`) fixed by (`date`) - as I was writing it out, I think I found the error.. thank you! This one worked
sum(sum(`Loan Count`) fixed (by `Date`))
@DashboardDude I had it in the back of my mind to just go in and create a new ETL but I didn't want to create a new data source for two cards.
If this helps, feel free to agree, accept or awesome it!
2
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