GrantSmith Coach 
-
Re: Assistance With Creating a Bar Line Graph
Hi @SLam I'd recommend reformatting your data with a date offset dimension dataset and using a beast mode to calculate the different between last year and this year. I've written about this…1 -
Re: Syntax for null
It sounds like your data might actually not be null but an empty string. Try something like this to handle empty strings and strings with just spaces: WHEN COALESCE(TRIM(`Building Status`), '�…4 -
Re: Aggregating Numbers
You can’t change how the data is displayed conditionally based on the type of chart selected. You can graph it as a bar chart and by default it will display the raw data table when the user clicks on…2 -
Re: What is the syntax to add a "if contains the following" in my logic
Use the LIKE command instead of <>2 -
Re: Magic ETL or Beast Mode?
There are perks for having something as a beast mode and perks for having something in an ETL. If something needs to be recalculated on the fly utilizing a filter then I'll go with a beast mode.…1
