damen Contributor

@nmizzell Thanks for the info - After posting this question and working through the process, I got to the point where I thought of just about the same solution. Thank you for confirming to me that this was in fact the way!

@ColemenWilson @david_cunningham Does this mean we do not have that same feature? Or am I looking for it in the incorrect spot? (The entire file is 502kb so no size issues)

@ColemenWilson @MichelleH Both of those worked. Thanks to you both!

@david_cunningham that just gave me a bunch of 0's

@MarkSnodgrass ah those trainings are coming back now. much appreciated, sir!

@MichelleH I am trying to use the file connector Sorry I did horrible math. It is 5,916,478 KB so its almost 6,00MB

@MichelleH Investors want to know the average dates of loans that are in bonds and indentures. It gives them an idea of potential turnover time for the loans in the categories we are describing.

@MichelleH it gave an integer that was not correct. I believe excel can do this but am not sure how Domo does.

@MarkSnodgrass Ok, so now the numbers are correct but it looks horrible. Is there a way to take out the just values (I want to keep the quarterly bar) from the bars and only keep the variance numbers? Can I delete those long looking lines? Thanks for your help on this though.

@MarkSnodgrass Yeah, that was my initial thought. Maybe I am misunderstanding how to input the dates into the date field? The comparison dates seem to be an issue.

Ah, beautiful. Thank you!

Ok, so I changed it to this and that worked. I can go day by day on the calendar filter on the card and get a 1 or a 0 but how to do make the beast mode look at a specific day. In this case, i want to day to be 7 days behind. @GrantSmith

@MichelleH Hey thanks! Super helpful article showing the capabilities - do you know of a video that shows someone on a website interacting/filtering/drilling down on a card? This is actually for an executive of the company wanting to see the interactive capabilities of Domo

@GrantSmith @DavidChurchman Thanks guys. That was what I was looking for.

@colemenwilson Sorry, I had left out a piece of information and that first card is a bit misleading - we don't want to actually show the credit scores that are greater than 660 The end card should look like this But the Y-Axis should be closer to 20% - instead it is taking the percentage of total loans throughout the year…

@MichelleH So here is my first attempt at creating a sequential column - this gave me that 'Latest Date' column above. I'm not sure where to go from here so that I can take expenses from ( (latest date 1) - (latest date 2) ) / latest date 2 and so on down the line (e.g. (p2-p3)/p3, (p3-p4/p4), etc

@colemenwilson Oh perfect. Much thanks.

@marcel_luthi Awesome! Thank you.

@brycec Got it. Yeah that was going to be my next question. Thank you.

@trafalger @MichelleH Thank you both for the suggestions. I will take a look at both and let you know what I found.

@GrantSmith Awesome - Thanks!

@GrantSmith This didnt change the look of the graph

@AnnaYardley Is the ranking system based on the amount of points we have received? Or are those points an additional bonus based on the ranking we have received? Also, does this mean the belt system has been done away with?

Sheesh. Thanks @MarkSnodgrass!!

Ok so I went in and did this and got this but am looking for this It feels like the error is in my syntax. @MarkSnodgrass

@MichelleH Beautiful. That worked out!

@RobSomers Yeah, so I have NOT in the middle of the column as well. I think I decided to break up some of the columns, replace, the concat back.

@GrantSmith I've been searching how to fix the syntax error and cant seem to find an answer

@RobSomers Hey, I think I found the issue. We had a few 'application_key' lines with a few non numerical values in them. Once we went in and removed any non integer values, they matched up as expected.

@GrantSmith Super helpful. Thank you and much appreciation for your help.