RobSomers Coach 
-
Re: Can someone help with a simple join?
@damen For the null values, would you mind just posting the Loan ID and the Application_Key before the alter columns for a couple of those rows? It looks like it would be an issue where the Applicati…1 -
Re: I'm trying to figure out a beast mode for a card for points?
@ggountanis Points to dollars: 'points' / 10 (ex: for 500 points, 500/10 = $50 Or going from dollars to points: 'dollars' * 10 (ex: for $50, 50*10 = 500 points) You're not really dropping a zero, you…3 -
Re: Filter is removing nulls plus specified value
@NateBI Nulls don't play well with logical operators. Null isn't the same thing as nothing, it really means that the value is unknown. Is null blue? SQL doesn't know so it treats it as if it meets th…2 -
Re: ETL Calculation
@zuchu You will want to use a Rand & Window tile: You'll do a sum of the costs and partition by the order number. This will give you the total of the order on each row that the order number appea…1 -
Re: Toggle series in bar chart
@jrtomici You can look into using variables for this. Make the inputs 'Total A' and 'Total B', and then create a beast mode like: case when 'Variable' = 'Total A' then 'Total A' (or beast mode calcul…3
