Hi David, This question is pretty specific to your use case and we have many customers who use only measures and others who create in the dataset. Best practices are as follows: If this total often has other filters applied which a user can change, t...

Hey Samdon, Using the SQL parameter in your LookML, you can add an ifnull or a regular if statement to remove these dates from your field. This will be dependant on the date formats you have in your dataset and also will be aligned to the syntax of y...