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!
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
More videos at: https://www.dashboarddudes.com/pantry
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
- 10.5K All Categories
- 7 Connect
- 917 Connectors
- 250 Workbench
- 466 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 193 Visualize
- 252 Beast Mode
- 2.1K Charting
- 11 Variables
- 80 Cards, Dashboards, Stories
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 246 Distribute
- 62 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 173 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive