Can someone help me with the syntax?

damen · November 2022

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

MichelleH · November 2022

@damen Can you please share what you've tried so far with the fixed function?

DashboardDude · November 2022

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

damen · November 2022

@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.

Scheduled Reports

Scheduled Reports

Can someone help me with the syntax?

Welcome!

Answers

Welcome!

Welcome!

Quick Links

Categories