Cumilative running total bar

Cherilyn
Cherilyn Member
in Charting

I have a running total bar that I am trying to have give the running total for all time but when I try to show only this year it is only giving me the running total since 1/1/23 (as if 1/1/23 started at zero)

Is there I way that I can have it still give the all-time total while only displaying this year as the output?

I have date range set to All time
graph by set to Month
date filter set to all time, but when I change it to only show a part that is when it changes the "start date" to not pull all time

Tagged:

Answers

  • GrantSmith
    GrantSmith Coach

    You'll need to pre-aggregate your data with a window function in Magic ETL in order to keep all-time around. Window functions in Beast Modes will only apply on the data that is available after filtering.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • pauljames
    pauljames Contributor
    image.png

    @Cherilyn something like this?

    IF I SOLVED YOUR PROBLEM, PLEASE "ACCEPT" MY ANSWER AS A SOLUTION. THANK YOU!

  • Cherilyn
    Cherilyn Member

    @pauljames
    this is the full chart I have (this output does not show all the column labels since there are so many)
    I want to be able to view just the current month but have it continue to use all the data from the before this year in the total

    Screenshot 2023-10-16 at 11.35.24 AM.png

Categories