-
pivot tile?
hi I am working in Magic ETL and am having a tough time knowing how to do what I am trying to do. Below I have a dataset with 3 columns shown that I need. What I need to be able to do is keep the msp last run date on the left hand side but then pivot the `delinquent payment 2` into column names then show the loan count So…
-
Missing dates - but not
Hi everyone, We have a few cards that have quite a bit of data to them. Over 1m rows in this case. When we open up the card view and try to find the date in the scroll menu, it doesnt show up. The saving grace is when we type it in, it works and is there (plus it shows in the card it self.) I am wondering, is there a way…
-
Sub-Category of a Category?
Hi All, We are working on a report that has a few different program_namesthat are summed up in a pie chart using orig_loan_amount. I have been tasked with trying to sub categorize our bonds using a taxable/tax-exempt designation The problem I am trying to overcome is that our bonds (identified by pool_name) are actually…
-
Can I filter by latest date?
Hi all, I am working in magic ETL and I have a dataset that gets appended each month. Most of the data is useless for what I am trying to use, except for the latest month's set of data. Is there a tile in Magic ETL that lets me filter out by latest date? I believe I could use a rank and order but am trying to not use…
-
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…
-
Running total spilling into a new column
Hi all, I have a problem where if the 'used' column goes above the 'authorized' column then we need to start adding to the 'used' column below. For example, when we use over 700m of our authority (total authority is 1.55 billion) then we need to start adding to the 2nd line of 'used' i.e. if we have used 790 million then…
-
Domo Changing Values
Anyone know how to make sure domo doesnt change values in my uploaded excel file? Clearly, everyone one of the values in the excel file has .XX and nothing more. Domo is adding values to the upload. How do I get this to stop?
-
Chart formatting
Hi All, I am working with a bar chart that has a data table. I am looking at it on the dashboard and am wanting to increase the size of the data table while simultaneously decreasing the height of the bars. Can someone help with that? Is it an option?
-
Date and Time formatting
Hi all, I am uploading an excel file into domo - we are hoping to be able to do this through the workbench eventually but, for now we are doing it through a manual file upload. In the excel file, we are tracking lapsed times for our call center. When I take the upload the data from excel in an elapsed time format (1st…
-
Data Formatting
Hi All, I am working with a number that doesn't seem that big but when domo ingests the excel file, it is wanted to add scientific notation to it. I need the numbers in the format they were entered in. I am in Magic ETL. Can anyone help?
-
How do I find the value?
Hi all, I have a 1.5 million row table that has been used many times over. For some reason, when I went to use it this morning, it was not wanting to work. I have a 'Bankruptcy Date' column that I feel pretty confident only has dates in it. I get this error code when I try to run this dataset through a dataflow. I cannot…
-
How can I auto send an entire dataset each week?
Hi all, I am looking to send not just a dashboard or an analyzer view of a dataset but an excel export of that dataset each week. Is there a way to schedule this or do I have to download it and send it manually? Thanks!
-
String Operations
Hi all, I have a column that either has 7 or 8 digits in it. I need it to have exactly 10 everytime I am working in magic ETL and am wondering how I can create logic to see if the column has 7 or 8 then add 2 or 3 leading 0s to the column depending on which case is true. Any suggestions?
-
Setting up specific Alerts
Hi all, My company is working with a webform. Two different departments are responsible for filling out two different pieces of the webform to make it complete. Department A has to go first. I do not want to set up an alert that everyone gets each time the dataset updates. I do want to set up an alert when column A has…
-
Beast Mode Syntax
Hi, I am trying to create a column that shows the year that a financial instrument was created and then I need to add 3 to it. It is going on the bottom of the x-axis so it will show up like '2022-2025' , '2023-2026', '2024-2027', etc. The problem when I go to write the beast mode below is that it thinks it is a math…
-
CSV separator but not
Ok so I have a string of data that has approximately 60 digits in it. There is no obvious delimiter - we just have to know the spot where to seperate. I am working in ETL and am essentially trying to do the SQL function where I start at a certain digit and end at another. I need to do this 7 times over so just using the…
-
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…
