damen Contributor

@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

@RobSomers Ok so I am still getting both of these functions wanting to run as string

@RobSomers Thanks again man. I didnt realize I needed the AND portion of that. much appreciated

Here is what I was thinking the syntax should look like for the current month, current year but I cant get it to return and values and the formula shows it as a string instead of numbers case when month(`Transaction Date`) = MONTH(CURRENT_DATE) then `amount` end

@RobSomers Thanks man. I appreciate the walk through and your patience

@RobSomers That makes sense. And which tile do I use for the 'A screenshot of which customer has the longest average time between orders and what is the average number of days?' part of it? I keep messing with the calculator and rank and window and cant seem to get it

@RobSomers Ok maybe another hint? I was able to essentially able to group or sort on customer ID by using the rank function but am still lost on how I could calculate the difference between rthe rows. Is there a way to create a new column where I would take the day of the year (ex: Jan 1 would be 1 and december 31 is 365)…

@jaeW_at_Onyx Yeah good distinction there. Within our company, the only ones who can delete the dashboard are the admins but I appreciate you breaking it down even further and explaining how it is actually the grants within each role that drive that.

@DaniBoy Hi Dani, I am new to Domo but do have admin privileges. Does this qualify me for this badge?

That works. Thank you

@RobSomers I even tried to do it without the instrument buckets beast modes taking place still no values.

@RobSomers For whatever reason, I'm not getting any calculations AVG(case when (CASE WHEN (`instrument` = 'first home') THEN '1st Home' WHEN (`instrument` = 'fannie mae risk share') THEN 'NoMi' WHEN (`instrument` = 'fha streamline') THEN 'FSR' WHEN (`instrument` = 'first home tax exempt') THEN '1st Home' WHEN (`instrument`…

Go to more -- admin -- pages and that is where one will be able to find the options. The only way to delete a dashboard is as an admin, within our company at least.