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