Hi,
I am looking to produce a simple report with the following headers
Date | YTD Value | Last Week Value
I have a dataset linked to my own fiscal dataset that has information for week start, year start, week number, period etc.
I am slightly confused on how to write a beast mode for the above as using the built in current_date function and year functions won't return the year based on my custom fiscal year.
How do people get around this?
This is a common use case for our customers.
Thanks