-
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?
-
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…
-
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…
