How to show month or year to date

Looker Q&A Looker
, ,
1

I would like to show performance of the current month (or year) excluding today’s date, how can this be achieved?

2

If we’re talking about a Looker explore, the way I’d do this is by creating two filters on the date field. One to specify the month to date period (“is in the last 1 months”), and one to exclude today (“is before (relative) 0 days”).

sam8_0-1714417882725.png
sam8_0-1714417882725.png851×883 48.6 KB

I’d probably use a similar approach on a dashboard - that is, create two filters - but I wonder if anyone has thought of a better way?

1 Like
3

You can check this post if you want to filter data MTD or YTD format based on user selection.
How to implement DatesYTD and DatesMTD using Look… - Google Cloud Community