There are versions of this discussion here and there. What I'm talking about is essentially people wanting to get the latest value of a given dataset and show it on a scorecard. However, the way to go about this requires people to create a new latest_date field and use it in a self-blend inner join.
This is clearly a hacky way of solving the issue. For one it's prone to error. For another, there's no way to then compare latest value with previous period data because the self-blend has filtered all but the latest value out. So it would be really nice to have the options "LAST" and even "FIRST" along the other aggregation options like (sum, min, max etc.) and not have to do the whole self-blend schenanigans.
Here are two instances of people talking about this issue.
https://www.reddit.com/r/Looker/comments/1dhfb30/show_the_last_value/
https://www.googlecloudcommunity.com/gc/Looker-Studio/Show-Last-value-when-Filter-Dates/m-p/870155
LinkedIn
Twitter
