I’m working on a dashboard in Apache Superset and trying to create a cumulative metric for one of my visualizations. Here's the context:

• I have a dataset with columns such as date, category, and value.
• I want to calculate a cumulative sum of the value column over time (date) for each category.

My Attempts:

• I tried using the "Time Grain" and "Rolling Window" options, but I couldn’t get the cumulative metric for each category separately.
• I explored SQL-based approaches in the dataset editor, but I’m not sure how to properly write the query in Superset's SQL interface.
• I also looked for options in the chart configuration, but couldn’t find anything straightforward.

Is there a way to calculate cumulative metrics within Superset?