Here's an easy one for you guys. I am trying to get a formula for average perf count per order. Naturally this formula below isn't correct because it is counting unique performances divided by unique orders. I think this is a simple Sisense syntax thing that I just can't seem to get right.
COUNT([Performance ID])/COUNT([Order ID])
Appreciate any help you can give. Thank you!
Sarah McLain
Can we try a bit of multipass aggregations and use an average, grouping around Order ID
AVG([Order ID] , [# of unique Performance ID])
https://www.tessituranetwork.com/Help_System/Tessitura.htm#Tessitura%20Analytics/Designing%20Dashboards/Multi-Pass-Aggregation.htm
Thank you so much. I knew that would be an easy one! Appreciate your help.
No worries. I'm without analytics for the middle term so I'm going by feel.
Always looking for examples of demystifying Multi-Pass Agregation. (the poor guy has a PR problem due a complicated name)