This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Glad you found that approach for average. If it works in some cases but
not on other places (e.g. depending on filter as you mentioned), I'm
guessing this is still a case like I described above where we have cells
where there's actually no data at al...
Hello ryukiman07, If I understand correctly, your issue is with the end
date: the logic is not including the end date entered by the user. I
would note that this is the standard way that date ranges are used in
looker filters: the end date is typical...
Hello liamsebestyen, Working with these nulls is tricky. Let me explain
what I believe you are running into. Generally speaking, Looker DOES
tend to show null/missing measure values as 0s. For example, the
standard sql of type:sum measures includes a...
Hello Panalyst, I recommend creating using looker's day_of_month
datatype to support this type of filtration. Please see the below
example. With this, users will be able to easily filter to
created_day_of_month_less_than_current_day_of_month = yes. d...