damen Contributor

Comments

  • @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.
    in Slicers Comment by damen June 2023
  • @marcel_luthi Awesome! Thank you.
  • @brycec Got it. Yeah that was going to be my next question. Thank you.
    in Slicers Comment by damen June 2023
  • @trafalger @MichelleH Thank you both for the suggestions. I will take a look at both and let you know what I found.
    in Data Snapshot Comment by damen May 2023
  • @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!!
    in SQL in ETL Comment by damen March 2023
  • 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
    in SQL in ETL Comment by damen March 2023
  • @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.
  • @GrantSmith Ok so I've gone through and downloaded the calendar.csv file and have it pulled up in an ETL. Now I'm on the 'MySQL' section of your article and all I'm trying to do is make this capable of doing a weekly comparison. (No need to have a daily, monthly or other intervals) I prefer working in ETL so I understand…
  • @MarkSnodgrass Ok so I am creating a YOY chart showing the last three years work of loan count - I took the bar chart off to make sure that I was able to get an output first. here is the chart - I am really only trying to get the summary number to display the percentage of production we have achieved this CY vs last CY
    in YOY count Comment by damen November 2022
  • @mhouston Yes @MarkSnodgrass So I did try that as well and I'm still not getting any data in the output
    in YOY count Comment by damen November 2022