I'm trying to do a running sum of a unique count of customers in a Tessitura Analytics Line Chart.
Anyone have an example of this working.
More specifically, I'm trying to do:
A running sum of unique customers by geo area for the season.
I Then I want to compare this years growth with the growth for prior years sales.
If this will help me, I do have the luxury of having access to the RMA Tessitura Analytics Cube.
Thoughts?
Thanks.
--Tom
How about this?
I created a custom formula:
Then saved that as a formula. Then in the next Value, I did:
Could you change 'Attended Count' to '# Constituent ID', then rebuild from there?
Thanks Nathanael Pearson ,
I'll give this a shot.
I originally thought that this would be simple
rsum ( count( [Constituent ID] ) )
To produce what I think I need. However when counting unique customers I'm getting a running sum of the unique customers each week. And because the same customer might have more than one order in two different weeks. I think that this is getting me funky values. The grand total <= to the Running Sum
Are you able to share a .dash file with your widget above?