Filter on "Month" is actually filter on "Date"

[Rui_Zhang1]

Anyone else got confused by this?

I used “type: date_month” in Lookml to generate the month. But I just noticed it’ll only re-format the final result in the “select” statement to “Month”. It won’t apply to filters.

My expectation is that “Month” is always formatted to the first date of the month, and when I do Month is in the past 365 days, filters would be the first date of the month is in the past 365 days so it would ignore May 2019.

I can see the benefit of doing it either way though but intuitively I was expecting the other way maybe because of the other tools we use.

To get around this, I can’t use the default “type: date_month” Lookml. Instead, I need to use SQL to get the First Date of the Month.