I am new to Tessitura Analytics, and have been asked for a line graph showing accumulated sales total (a "running total") over time.
How is that done? I easily created the same chart for sales by days out from performance.
Thanks in advance for any help!
Note: I have tried the RSUM function, but in this case get "Error querying Elasticube.".
Hi Steven,
Is this the kind of thing you are looking for? Try using "Order Days since OnSale".
cheers
Nancy
Thanks for that; I can't seem to get a running total to work. What formula does this widget use for "Paid Amount"? I try using RSUM, and get "Error Querying Elasticube" and "Unknown Error".
Yes that's what I'm using too - RSUM([Total Ticket Paid Amount]) and that works for me. Not sure why you are getting the error ... if no one else has any suggestions, you may need to submit a support ticket to Tessitura?
Interesting; my formula is just RSUM([Ticket Paid Amount]). Do you think that makes a difference? And again, thanks for your help with this!
3036.TheComedyofErrorsProductionSales.dash
Can you import this dashboard? That chart is part of it. Does that work for you?
Hi Steven. Try importing this and changing Season & Cube. It should look a little like this otherwise you might want to raise a ticket or post your dash here and I'll have a look
7762.RSUM curve.dashoops Nancy beat me to it
I think it does make a difference - I use RSUM a lot and my formula is also RSUM([Total Ticket Paid Amount]) - if I switch it to just [Ticket Paid Amount] I get that same error.
I have had issues where I'm editing a regular SUM formula and just add the R where it creates that incorrect formula - I suggest deleting the value, and starting from scratch, going straight into the Formula (fx) editor when adding the new value and typing RSUM() and then finding and selecting "ticket paid amount" which should default to the SUM when you select it.
Hope that's helpful!Sarah Covie
This is what I was looking for too. Thanks. Is there a way to plot multiple performances on the one graph?
Use the Break By function in the widget I use that to Break by Production Season
Thanks Heath! So simple :)
SUM([Ticket Paid Amount]) and [Total Ticket Paid Amount] are the same.
Hence you can use the formula as RSUM([Total Ticket Paid Amount]) or RSUM(SUM([Ticket Paid Amount]))but not RSUM([Ticket Paid Amount])
Hope that helps
Yes, yes I am ;)(apropos of this convo I also spammed you about ANZTRUC :D )
hehah. Yes just got back to you about that. As is telling from my question, we haven't come up with anything nifty yet.
.... yet