Creating period comparisons with QuickSight's periodOver and periodTo functions

Learning Center Articles
, , ,
2

HI! This post was incredibly helpful and set the foundation for my visual. One change I made was making the graph a running sum by using the following formula:

runningSum(
periodOverPeriodLastValue(sum(Total), {Billing Record Create Date_USE},MONTH, 1),
[{Billing Record Create Date_USE} ASC],
[truncDate(“MM”,{Billing Record Create Date_USE})])

Today though I unearthed that the above formula (as of 30th in Nov) accounted for the …27, 28, 29 in October but skipped the 30th and summed the 31th. My general question though is this the right approach to visualizing this as a running sum?

Thanks