-
Translate this error
Hi, I am trying to write a weighted average formula into an ETL. I am not sure what this error means. Can someone help me with what the syntax should look like so that I aggregate it properly? Thanks in advance.
-
YOY Progress Bars
Is there a way to compare YTD (fiscal year) this year vs the same period in another year? Current the progress bar is counting all of FY 2021 and comparing that to FY 2023, which we are only about 50% of the way though. Ideally this progress bar would show closer to 50% but I am not sure how to compare just the first 6-ish…
-
How can I format the date in a YOY chart
Hi all, Is there a way to format the date in a YOY chart? The tables in domo allow for you to customize the dates (1st picture) but I am working with a YOY chart and it doesn't want to let me do the same thing. (2nd) I am trying to take the year off of description at the bottom of the Y-axis and just have the month display…
-
YOY count
Hi all, I am trying to get the loan count of this year / the loan count of last year and for some reason, I cannot get an output - here is what i have tried so far. Any recommendations on the syntax?
-
Is there a way to filter out integers that are longer than 7 digits?
Hi all, So I am working through an ETL and the logic needs to be able to include the bottom two values into a bucket but take the top two out. I am using a formula that looks something like this: what it really need to be is: when `loan number` like '5%' and less than 7 digits then '' is there a way to program that into…
-
How can I edit this card to only show one column's data label?
Hi all, Below is a visualization that shows three different data labels. Is there a way to only include the data labels for the "variance" line? We already keep the production numbers in a different table on the same dashboard so being able to clean up the visualization a little bit and only include the variance number…
-
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 do I group by a integer but take into account both instances of the integer?
My company has a demographic table like the one below where we keep true or false info on borrowers. When the loan has two borrowers, we create the same loan id twice in our system. I am working to create a minority table but I have to take into account BOTH borrowers. If either row (1,1 - 3,3 in this case) has a true in…
-
how can i create a calculated field based off buckets?
Hi all, Recently I created pricing buckets for the amount of loan a borrower took out. This works Right now, we have two different visuals that show 2021 vs 2022 This is ok but we would rather be able to see both of these graphs in one with the different years in different colors. Is there any way to do this? The only way…
-
Can I use a year filter in a column while simultaneously not using it while building a table?
On the left is a breakdown of all 2022 loans by county - on the right is an all time breakdown by county. Is there any way to include these both in the same table? im having trouble trying to show both instances in the same visualization Any suggestions?
-
How do I write the syntax for YOY % change?
Hi all, I am trying to create a calculate field where I am able to see only the change from year to year in average purchase price. I understand the math to be purchase price1 - purchase price 2 / purchase price 1 but I am not getting the correct output when I try the syntax Here is what i have so far: Any suggestions on…
-
How do I format?
Hi all, I am working to generate a report but am not sure how to calculate in Domo to get the visualization right Right now, we are looking a property type breakdown by year - included on the y-axis is the number of loans we had each year. We are trying to keep the years on the x axis but only show the property type…
-
Can someone help me with the syntax?
I am trying to get the percentages of each of our fields displayed in a table but I have to take column 1 (delinquent payment 2) and divide by column 2 (loan id) when I run just the first line, I am able to get the correct calculation but I need to get all of the values calculated so I can display them on one table. Any…
-
Copy an entire dashboard
Is there a way to copy an entire dashboard and just rename it? My company wants to recreate the exact same dashboard but have one that display fiscal year and calendar year with the exact same formatting. Besides going through each individual card and formatting the dashboards that way, is there a quick copy and paste…
-
Why have the dates changed?
So I have put together a multi data source dashboard for our company. Yesterday, before everything ran overnight, all of the years worth of data was showing up. This morning, without changing any filters, the graphs are only showing about 15 years worth of data. My instinct said that somehow the update caused to data to go…
-
Fiscal Year Beast Mode
Hi all, I am trying to create a filter on the dashboard for us to be able to filter by fiscal year The problem I am running into is that we have already contacted Domo about giving us the fiscal year option so all of the cards below this filter are already in fiscal year. The filter above is not. I have a simple beast mode…
-
Exporting a filtered file
Hi, I recently joined multiple data sources together and we are going through and sifting through the data flow. Almost everything looks good except 5-6 columns have nulls when we are expecting data. For example we have 109,000 thousand rows and all 109k have loan IDs in them but there are only 105k rows with purchase…
-
Formatting a single number card
Hi all, Simple question here. Is there a way to format the number on this card to be a normal number? We had 3,108 Loans last year and I want the number to be in that same format but the best I can do is 3.108K which doesn't make much visual sense. Any suggestions? I have tried all the formatting options that make sense…
-
Syntax for null
Hi all, I am trying to create a formula in ETL that deals with the null values in multiple columns. So far, no matter what kind of formula I use, I am unable to get the blanks filled in Here is what I am trying right now based off of all of the other posts I have read Again, nothing is turning up XYX like I would expect. I…
-
Data Flow Help
Ok this one is going to be a long one. My company keeps track of loans on an excel sheet. We are trying to migrate that excel sheet into a dataflow onto domo. There are a lot of different data sources we pull from to create this spread sheet but I am trying to bring together and formulate an ETL from just two sources right…
-
Magic ETL or Beast Mode?
Hey everyone, I'm using data that basically needs an (=if) statement like we were going to be using excel-- We have two columns called current income and qualified income. The 'income' column needs to populate with 'current income' if another column, called 'instrument' reads 'first home' otherwise, we need to use…
-
Why are my filters not working in Magic ETL?
Hi all, I'm confused as to why my magic ELT filters are not working properly. Is it something I am doing wrong? How do I go about fixing this? In the first picture, I am in the data set and have set a filter on the 'time_stamp' column and its filtering the data just fine. For whatever reason, when I go to magic ETL and do…
-
"current year, current month" and "previous year, current month" Beast Modes
Hi, I'm trying to create a 'current year, current month' and 'previous year, current month' beast mode. To this point I have created a current year to date but am not sure of the syntax. I have watch multiple videos and have searched high and low through domos resources. Any help with the syntax would be helpful Here is…
-
Fiscal Year Comparison
Hi, I am trying to create a running total of fiscal year 2023 vs the same time in FY 2022 and FY 2021 but all on the same chart. Right now, I currently have this Essentially what I am trying to do is take the three green bars from July 1 of this year, combine them into one column and then do the same for the pink and blue.…
-
Magic ETL Help
Hi, I am going through the Data specialist practical test and am running into troubles. Here are my instructions: Up to this point, this is what I have done: Because I am not an admin on my company network, for those familiar to this test, I was unable to complete the join on the workbench due to accessibility issues.…
-
Beast Mode Examples
Sorry in advance if this is already a thing but I haven't been able to find it. As a new user to SQL, I understand the very basics. Beast mode provides a really simple and easy way to apply some of what I know and quickly help with new calculations. My issue, and where the idea comes in, is that I don't know where to go to…
-
What is the best way to calculate?
So I'm using a grouped bar graph and am looking to try and calculate the difference between two of my columns that were created. My company calculates the average spread on loans broken down by lenders we use. I was able to separate those average spreads by product by adding the products to the 'series' drop-in at the top.…
-
Load an dataflow from Magic ETL
Hi, I think it would be helpful to be able to choose a previously created data set and load it into Magic ETL from a blank ETL screen. Thanks, Damen