-
Case when SYNTAX
Hi all, I am trying to write a case statement for a column when we see a null to grab another column. I am not sure why I am not getting the output expected. Can someone take a look and maybe advise? Essentially 36534370 and 36534369 from the investor_loan_id column should be in the left column as well. **I've tried to…
-
Looking on a specific date
Hi all, I am working in Magic ETL. I have group two different datasets on their 'lock_dates' I have created a calculated column where the number of locks are counted in each data set. Then I created a column that told me if dataset 1 matched dataset 2. All of this is shown below The issue I am running into is seeing that…
-
locks = locks?
Hi all, (I recently posted something similar but updated my dataflow to a new output so wanted to share and clarify) I've got two columns, rate_locks_powerlender and rate_locks_powerseller, that I need make sure are equal to each other. The power lender is slower to update so we do not have data later than 9/11 so I am…
-
True/False Beast Mode Syntax
Hi All, I am currently working with two joined datasets. Each dataset has a date for each row that gets added. I have outer joined those datasets and am now trying to make sure that the number of date entries are the same in each data set. I can visually tell that they are the same but I am trying to write a beast mode to…
-
Interactive live website dashboards
Hi, My company is looking into the ability to add interactive live website dashboards so our audience can filter through data on their own using our website. I am vaguely familiar with Domo's capabilities when it comes to this and am needing some resources. Can anyone provide a link or two with a video that shows a live…
-
Legend in Pie Charts
Hi, It seems that something recently changed so my pie charts are displaying the total on the side and in the summary number as well. The graph on the left is how I am trying to get it to look but I cannot figure out why the graphs on the right are showing the total in the chart. Was this a recent change? Any suggestions…
-
Beast Mode Fix?
Ok so I have a filter deny on a beast mode and I need it to be different but I cannot figure out the dimensions. The problem - each of the months below needs to equal 100% and within each month, we need a percentage of that 100% that are in the 'credit score buckets' Currently, the 6 columns add up to 100% and I cannot…
-
Rank and Window? Lag?
So I have a dataset that captures quarterly expense data. I have been tasked with adding an 'expense ratio change column' Basically, I need to know the % change of expenses changed from quarter to quarter by project I know the math on this ((p2 - p1) / (p1)) but am not sure how to tile it in domo to make sure it is taking…
-
Slicers
Is there a way to build a dashboard with a slicer on it that only works on a few cards? Right now, I am seeing the slicers working on every card on that page. I know I can build a sub-dashboard but am wondering if there is a better way than that. Any suggestions?
-
Weighted Average Calculation
Hi, I'm working with a dataset and am wanting to make sure I am going to get a weighted average of our mortgage rates. We have loans that range from 100k-400k and each loan has an associated mortgage rate. As an example, we have two loans that go into the same security that are 5% and 5.5% Loan A is worth 200k and loan B…
-
Filter by Rank?
Hi, I am trying to show and display the top 10 values of my 'physical vacancy' column listed below. I know I can go in and create a new column that shows rank but I don't want to alter the dataset. Is there a way to do this using a filter on the card? Sometimes the data changes so the top 10 today will not always be the…
-
Data Snapshot
Ok so we have a dataset in one of our databases that periodically gets updated. Every so often, we have new data that gets added AND some of the old data gets modified. (Sometimes we have loans that get modified and we need to keep the original 'value') I am trying to create a snapshot of the original data - on a quarterly…
-
Chose the newest date available
Hi All, I am working to combine two tables. The first step I need to take is to filter the project_number by with the newest report date available. The example below shows two different project numbers The first one has the last report date as Q3 2022 - we need to capture that input The second project_number has q4 of 2022…
-
Formatting on cards
Is there any way to manually select where the numbers are displayed on a bar chart? I've got 11/12 months that dont conflict with display data but 1 month that is throwing the rest off. Is there a way to manually take care of this? I need all of the numbers to display from left to right - not top to bottom.
-
SQL in ETL
Hi All, I'm currently trying to recreate a MySQL flow in Domo to ETL. One of the first things we are doing in a table is taking out extra characters from a column to create a new trade_id Here is how we are doing it. when I go to add the formula tile and copy and paste this syntax, ETL is saying it doesnt recognize the…
-
String to date
Hi, I'm trying to take the 'DUE DATE' column below (covered by the mouse) and turn those numbers into dates. 20123 is supposed to be 02/01/23 The solution I first thought of was to just split the columns but because it is showing up as text, it wont do that. Is there a beast mode to just pull the last two, the middle two…
-
search and replace
Is there an equivalent to search and replace in ETL? i have a data set that I need to change the word 'Not' to something else - the problem is i only want to change that word and only that word. Any suggestions?
-
Identify a duplicate
Is there a way to create a column that can help identify a duplicate from another column? Below is a list of loan ids that we have and some of them have coborrowers but some dont. I dont need to remove the duplicates but I would like to create a new column that can identify quickly which one is a coborrower. Is there a…
-
Editing Capabilities
Hi, I'd like to have a bit more freedom to edit some of the visuals I work on when it comes to creating a report. For this one specifically, I would like to be able to make the font size in the legend bigger and it sounds like there isn't a way to do that.
-
Can I change the font size?
I am having trouble changing the font size on the legend of a generated report. Is there a way to do this? Do I need to do it in the card? Or do I have to use the PDF editor?
-
Can someone help with a simple join?
This is a super simple problem, not sure what is going on but I am hoping a fresh set of eyes might help. All I am trying to do is take the 'property_address' column from the powerlender table and use that information onto the foreclosure table - foreclosure is otherwise all ready to go. Both tables have a loan_id (one is…
-
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…