Hello!
I'm having a bit of trouble displaying the data the way I want.
I have data on the number of sales for a product X, and I want to use an area chart to show the cumulative sales evolution throughout the year, month by month.
For example, if by December 2024 I had sold 1000 units and in January 2025 I sold 200 more, the value in January should be 1200. If in February I sold 50 more, the value should be 1250. The issue is that when I apply a filter in Visualize and set it for the current year, it filters the data instead of keeping the accumulated total. That way, I only see the 200 sales from January, instead of the total 1200, and 250 from February.
I need a way to "zoom in" on a specific time range without losing the accumulated sales from previous months, if that makes sense? I wouldn't have an issue displaying all my data, but it goes back to 2005, making the chart completely unreadable.
Thank you so much in advance!