Comparing a Running Sum to Same Time Last Year with nulls

ColinHaze · 2025-01-06T15:01:01+00:00

There was an error rendering this rich post.

Hi,

I am having a hard time comparing a running sum to the same time last year if there is a no value.

The beastmode I am using to get the running sum for each year is as followed.

SUM(Count(ReportNumber)) OVER (PARTITION BY Year ORDER BY AccidentDate)

However, not all accidents occur on the same day of the year, so my question is how can I modify the beast mode to find the max value leading up to the day of the year.

I attached a photo below to show you the issue. In the prior year coulmn I am trying to carry the two down until it becomes 3.

Is there an easier way to accomplish this? Thank you!

Find more posts tagged with

Accepted answers

ColemenWilson

This doesn't answer your question, but a suggestion, since I built this card yesterday and have it on my mind, is to use the running total chart and add a YoY comparison and then show the data table under the running total line chart. This wouldn't require any beast modes and I think is a helpful visual.

ColemenWilson

Interesting, it only seems to fill in when looking at a previous time period for the YoY comparison. When I use current year vs previous year it doesn't fill in.

All comments

ColemenWilson

ColinHaze

ColemenWilson

I didnt know if DOMO had a card like that or not but its Exactly what I was looking for! You just saved me a lot of time thank you!

ColemenWilson

Awesome! And you can of course switch it to graph by day, week, whatever to fit your needs. Glad I could help!

ColinHaze

ColemenWilson

My only question is, how did you get the area to fill in gray?

ColemenWilson

Interesting, it only seems to fill in when looking at a previous time period for the YoY comparison. When I use current year vs previous year it doesn't fill in.

ColinHaze

Odd, Thanks again!