Hi -
In many of my use cases I’m converting granular data and rolling it up based on a date hierarchy (similar to Pivot tables in Excel)
The most common case for me is Year/Month. To do this I typically convert using fuction
left([Date],7)
Before:
After
It would be an interesting feature if this concept was available during the aggregation or as a quick action as I find myself repeating these steps frequently.
Nothing critical just thought I’d pass it to the community as I was thinking about it
- Adam