I need to build a table that brings the cumulative number of fired employees, by month, since the beggining of the company. I’ve managed to build the metric and the table brings the monthly numbers correctly, when I don’t apply a filter. However, when I filter this table to show only the last 12 months, the results are not cumulative anymore, it shows only the number of fired employees of that month alone. How can I overcome this?
I’ve tried using many functions, like RUNSUM, BY, WITHIN, ROWS BETWEEN, but none of them seems to work.
I’m new to MAQL and kind of struggling with this problem. Any help is welcome. Thanks!
Best answer by Moises MoralesView original