-
lookup function in beastmode?
Hi all, I have a table that has these columns: loan number other loan number first principle balance hi type description 2nd mortgage amount is the field we are trying to create The logic is such: when hi type description = '1st mortgage' and other loan number is > 1 then i want to look up the first principle balance of…
-
Order by in ETL?
Hi, I am working on taking some mySQL dataflows we have stored and turning them into MagicETL dataflows. I am wondering, does anyone know of an 'order by' function in ETL that is applicable? TIA
-
Presentation
Hi all, I am a analyst in my company and have been asked to give a presentation to all of the internal managers on domo, its uses and how they can start using it. I am wondering, are there any good resources for putting together a high level presentation that you all have seen? Does anyone have a PowerPoint they have used…
-
How do I filter by most recent date?
We have a dataset that get multiple 'loan_id' entries recorded (shown below) However, when I go to remove duplicates on any of the columns, I generally get the wrong loan amounts. The correct loan amounts are always the ones with the latest 'time_stamp' I am hoping to remove any duplicate 'loan_id' based off the latest…
-
Median Calculation
Does Domo calculate median? How so? I am building a card - a table specifically - and am looking to put median price instead of the average. How is this possible? And most efficient? Thanks
-
Connecting to a large dataset available for download
Hi All. I am working with try and connect to a few HMDA data sets that are available and am not sure how to do so. I remember a consultant we had connecting to data from a federated data source but also, not sure if that is what we are needing to do. More specifically, we are trying to connect the Loan/Application Records…
-
Average Date Calculation
Hi, Is there a way to do an average date calculation in Domo? I am working with a table that has close to 30k rows and all we are trying to do is get an average date for the date column. Is this possible? I looked in the beast mode functions and could not confirm it was in there. Thanks
-
Bucket Ordering
Hi, I am working with pricing buckets of home loans. I have created two case statements. One that puts each loan id into a piricing bucket based on the loan amount. the second is to order those buckets in what would be numerical order. I am getting a graph that, when the bucket order is being applied, doesnt want to bucket…
-
Quarter by Quarter comparison
Hi All, I am trying to have analyzer display the percentage change from 3rd quarter of each year to 4th quarter of each year. Currently my graph looks like this but I am unsure how to get the graph to display it I have tried to format using a period over period chart but cannot figure out how to only show 3rd quarter to…
-
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…