RobSomers Coach 
-
Re: Heat Map Hours Off
@chrissy Your hour beastmode column is in text so it is sorting it in aplphabetical order, so 1 pm comes right after 1 am alphabetically speaking. Try creating another beastmode that gives hours 1-11…1 -
Re: Table card percentages
@ggountanis You'll need to use a FIXED() function to get the total of all the categories combined: SUM(1)/SUM(SUM(1)FIXED()) -This assumes that your data is at the employee level3 -
Re: Calculated Column using Current Date
@JenHarrison It looks like your missing a ) after CURRENT_DATE which is resulting in the syntax error. Though you will probably want to use the DATEDIFF() function instead as in your current beastmod…4 -
Re: Ranking card
@zuchu You would use RANK() or DENSE_RANK() in a beastmode on your card. It would be something like this: RANK()OVER(ORDER BY SUM('Sales') DESC) Then put your companies as a column and your beast mod…3 -
Re: Why is a field not allowing me to exclude it?
@nshively When you you join your Groups to your original dataset, if an Employee from your original dataset is not in your Groups dataset, then Domo (SQL) will make it a NULL. So your values are actu…1
