Hello
I have some issues with running sum function. I’m trying to sum some values over time and divide it by some dimension. However on dates, when I do not have any value for certain day and dimension item, then that value disappears completely.
As you can see in marked dates I am missing purple values in next week.
Calc field used:
runningSum(
sum(coalesce({measure},0)),
[{date} ASC],[{dimension}]
)
Do you know any workaround? The only one comes to me is to create artificial records per date per dimension, however it’s not an option for me, because of many different dimensions and amount of dates to cover. I’ve also tried to right (and full) join dimension, however it didn’t work for me.
Thanks