damen Contributor

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.

@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

@mhouston Yes @MarkSnodgrass So I did try that as well and I'm still not getting any data in the output

@MarkSnodgrass Awesome. Thank you

@MichelleH sum(sum(`loan count`) fixed by (`date`) - as I was writing it out, I think I found the error.. thank you! This one worked sum(sum(`Loan Count`) fixed (by `Date`)) @DashboardDude I had it in the back of my mind to just go in and create a new ETL but I didn't want to create a new data source for two cards.

@McSQL Yeah i thought of doing the same thing -- for whatever reason when I add the '2022' formula into the values field, it wants to change the entire dataset with it.

Well, dang. Thanks for the link

The 'graph by' setting is set to graph by year. Not sure why the output is like that.

@GrantSmith Hopefully this comes off the right way but is that the simplest way to do it?

So I think by using the CURDATE function in there its only wanting to give me the change in this specific year. You can see at the bottom there is average income numbers filled in the 2018 year. How would I change that syntax to include those years in the visualization as well?