RobSomers Coach 
-
Re: Formatting a single number card
@damen Under General chart properties, set Divide Value By to 'None'.1 -
Re: ¿How can I classify an object based on conditions?
@andersson_morales19 You're case when statement isn't working because of the waterfall. CASE WHEN statement go through each part of the statement and once a condition is met, it doesn't evaluate anyt…3 -
Re: "current year, current month" and "previous year, current month" Beast Modes
@damen Current month: case when YEAR('Transaction Date') = YEAR(CURDATE()) and MONTH('Transaction Date') = MONTH(CURDATE()) then 'amount' end Previous year, current month (assuming this means same mo…3 -
Re: "current year, current month" and "previous year, current month" Beast Modes
@damen Just noticed that the beast mode you posted of what you're using, you put: then 'amount' end You're using 'amount' as a string so you're saying when the row meets that condition put in the wor…2 -
Re: "current year, current month" and "previous year, current month" Beast Modes
@damen The beast mode you have is for current month, not current year. It will only have values for the current month (2022-Sep).2
