damen Contributor

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

@RobSomers its def the amount column that contains the values. I'm confused. are the integers not calculated as values? The first beast mode (2nd picture) where we are only calculating current year, returns values

The first picture is what works for current year. I tried to just enter in the 'AND MONTH' portion of it and try the same format (and a few other ones) but again, no values have been returned at all.

@RobSomers I'm still running into the same issue in that I'm not returning any data when I use that formula. I've tried different variations of it and nothing returns any values. the syntax does make sense tho. i just am not sure what i am doing wrong.

@RobSomers Yeah, my bad. I did get the current year and previous year to return values after a few tweaks to it. I am trying to do the last two on the list now.

@trafalger I'm confused by that answer. Maybe I can show something that would explain what I was aiming for a bit better. My apologies. In the blue column is ALL of FY 2021 stats, Red 2022, Green 2023. The problem I am having is trying to filter YTD from fiscal year 2021 and 2022. Essentially I need it so the blue only…

@GrantSmith so I did get them to show up as a number but values are still not showing. **disclaimer: this is for the domo data specialist practical test