To show the date range of a report page, we usually add a date range selector somewhere around the top. But what if we just want to show the date range, but not necessarily allowing the viewer to adjust or change it?
This is useful for a table or component that is located below the fold, where the date range selector is no longer visible, or for when a chart or component isn't connected to the page level date selector, but has its own dynamic date range applied to it.
Other than the function I used in the video above, you can also use these functions:
MIN(Date)
Which is simpler, and returns Date in Jan 1, 2021 format, or
CONCAT(
"From ",
CAST(MIN(Date) AS STRING),
" to ",
CAST(MAX(Date) AS STRING)
)
Which returns a string of text like below, within the scorecard:
From 2021-12-09 to 2022-01-05
📩 Receive my weekly Looker Studio tips
🎥 Subscribe to my YouTube channel
🖇 Connect with me on LinkedIn