Hello! This hoping is an easy one - I've got a Running Sum for Contributions in the last 3 years of a specific Campaigns, broken by Campaign. The Running Sum numbers I'm getting are right, but I have the gaps in the chart on days when no contributions were processed...
I know on a regular line chart there is an option for Continuous Timeline and "Display Missing Values as Zeros," but I think because it's a Running Sum, those options go away. Anyone else have this issue or a solution to it? It just makes the chart very hard to read and I'd rather have flat lines on those days instead of gaps.
Thanks!
Lily
Inside of you RSUM parentheses , add “, TRUE” to make it continuous. The default setting for RSUM is FALSE (not continuous).
RSUM ( [Value] , TRUE)
Thanks Neil! I'm not sure if I'm doing something wrong, but it doesn't seem to be working for me - I tried recreating the Formula from scratch, with the TRUE value added in, but my graph looks the same.
I also tried your TRUE suggestion. and did not get fully continuous running sum lines.
There is something in the description of this parameter about "two dimensions or more." I'm not clear that my widget meets that requirement some how.
Here is my current formula:
results above.
I think someone had shown this during a TAFFY or TAMATO meeting.
If you copy the a Tessitura shipped dashboard that has a similar widget (in this case, the shipped Production Sales dashboard has a Running Sales Total example). Edit the widget. Click the 3 dots in the upper right corner. Under Actions, select Edit Script. Then you go to the affected dashboard widget and repeat (Actions -> Edit Script). Paste the copied text into the new widget and apply. Click off the dashboard, then back in, and the lines will not be broken.
It's not perfect- sometimes I get extra dots over some parts of the lines - but it definitely helps.
Thanks Christine, I was looking up the code that I paste into the Edit Script of the widget. You beat me to it.
The original script was posted by David Judd. Thanks David!
Thank you so much, that helps a ton!