-
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
