damen Contributor

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

@MarkSnodgrass Simple enough. Thank you sir.

@tlammie1806 The best way to get 100% of the way there is to fix the data input. If that isn't a realistic option, splitting each word into columns and saying that the first word is FN the last word is LN and everything in between is middle might be the best option. Without knowing which name is exactly which, there is no…

That last one just shows its only giving me a count of all loan IDs that are in delinquency - for whatever reason it doesn't want to seem to do the division part of the problem. @RobSomers

@RobSomers Still getting all 1.00 as the value input. Not sure if I'm understanding you correctly on this. My apologies Also, I did try your exact same syntax before I switched to count(loan id)

@RobSomers Ok so I pulled up the function video on Domos youtube and got a better sense. This seems to me to be the most logical answer but I'm only getting 1.00 as the output for this. Basically, I need the % of loans that fall into each bucket. This table would normally work but I have to take out the "current total" row…

@MarkSnodgrass Awesome. Yeah. That worked. Thank you.

@RobSomers Its just a regular column. We aggregated it on average purchase price by year. I just went through and removed all aggregates and changed from ave to all the other ones and the same issue is coming up.

@MichelleH So the 2nd screen shot is showing that the dates are available in analyzer. That view if of the 'data' table while in analyzer. The problem is the card isn't showing all the available data. Here is a different view but basically showing the same thing that was mentioned by the previous post/pictures. This is the…

@MichelleH Yes. Most of the source data comes from databases that aren't rewritten but appended. The earliest dates from all sources in this dataflow are like this and have not been overwritten.

Ok so I fixed the () issue and now I'm back to square one. This is the new filter based on that coding above. when I put the year function in front of it, I only am able to get 2022 to show up

@billobi Thank you! That is much easier than how we were previously doing it. Much appreciated!

Awesome man! Thanks

Beautiful. Thanks for the help. Really awesome btw.

@RobSomers Awesome. I don't quite understand that 2nd part but I used that syntax and it worked well. Thank you both

@MichelleH Ok new question So I am trying to recreate this pivot table but do it in a way that it just creates the data table using an ETL Here is what i have done so far Here is what I am getting How come the formula that is supposed to be grouped by instrument_name is returning a 100%? I have tried to group by…

@MichelleH That worked. But it was doing both. I tried to save and run it and it returned 0 rows with that same filter. I just changed the row limit and although there aren't even 10k rows (thats why i was trying to filter, to reduce the rows) changing the view to 400k worked. Weird. Thank you tho!!

@grahamwalkeradv Here is a new update from this year on fixed functions. I'm not entirely sure I understand exactly what you are asking but this video goes into pretty good detail on how to utilize fixed functions

@MichelleH Yeah, sorry. Here are the updated views. I'm currently dealing with the 2nd picture being able to returning values and the first picture doesn't.