There is one issue with the code that I have noticed nobody has mentioned. When you are applying the allowed values to month and year you are not taking into consideration the month of February, that has only 28 days, or months with 31 days. In regar...

Try this calculation. sum(if(${user.is_registered},1,0)) This will show you the the sum of all “yes” in each row of the calculation column. So if there are 50 registered users, each row in this column will show the number 50.

Try the options explained here. Looker Documentation named_value_format LookML parameter: Create a custom value format to use with value_format_name. The negative values will appear in parenthesis.

@fabio1 Would you be willing to post the “cleaner” way to implementing this code now? I would greatly appreciate it.