Hi Metabase Team
I enjoy using the Trend visualization in Metabase to provide an overview of values over past time periods, whether weekly, monthly, or annually. However, there is an issue with how this function calculates previous values. Currently, it uses the date of the last data entry rather than the day the dashboard/question is viewed.
For example, if I am in a weekly meeting displaying total sales with a cumulative sum, the value for the previous week is not calculated as today’s date minus 7 days. Instead, it calculates from the last data entry; if that was 3 days ago, it shows data from 10 days ago, rather than the last 7 days from today. Additionally, if there is no data for that period, it indicates that no data is available. Ideally, it should use the previous data, as this would imply there has been no change.
thank you for your attention
Best Regards
Taufik