I have two datasets: one with the daily goal for the number of leads and the other one with the daily number of leads per type (there are 3 types os leads).
I've then created a klip that brings the daily number of leads and the percentage of the goal that day for a specific month, defined by a User Input Control. This works fine but when I want to bring make a cumulative klip for the selected month, it acumulates the date since the start of the dataset, and not within the month.
Dataset Goals example: @goals
Month Day Goal
2021-01 2021-01-01 100
2021-01 2021-01-02 120
2021-01 2021-01-03 90
2021-12 2021-12-30 130
2021-12 2021-12-31 60
Dataset Results example: @results
Month Day Type Leads
2021-01 2021-01-01 A 60
2021-01 2021-01-01 B 50
2021-01 2021-01-02 A 80
2021-01 2021-01-02 B 40
2021-12 2021-12-31 A 70
2021-12 2021-12-31 B 60
And I have an User Input Control 2021-01 to 2021-12 and put Hidden Data Filters that match the user input in each chart.
For the simple chart I use the X axis as @goals, B:B and the series as
LOOKUP(!X Axis: Data, group(results,@B:B;), GROUPBY(results,@B:B, results@D:D;))
and it works fine.
For the cumulative chart I tried
LOOKUP(!X Axis: Data, group(results,@B:B;), CUMULATIVE (GROUPBY(results,@B:B, results@D:D;)))
CUMULATIVE (LOOKUP(!X Axis: Data, group(results,@B:B;), GROUPBY(results,@B:B, results@D:D;)))
Both work for the first month but for the second it brings all the cumulative results for previous months.
Any suggestions on how to solve this?
Thanks in advance.