Divide/Multiply/Add/Subtract Analysis Workspace Summary Metrics

Avatar

Avatar

AdamGreco

MVP

Avatar

AdamGreco

MVP

AdamGreco
MVP

06-03-2018

I would like the ability to create a new analysis workspace summary metric that is a formula (at first just divide, multiply, add or subtract) of two existing summary metrics. This is useful when there is no easy way to create a calculated metric due to different time frame needs, etc.

For example, if you have a summary metric for Daily Average of Unique Visitors and you want to divide it by the Weekly Average of Unique Visitors, it can be difficult. But if you had both as summary metrics (based upon underlying data tables), you could divide the two resulting summary metrics to make a new summary metric that is Average Daily Unique Visitors / Average Weekly Unique Visitors.

3 Comments (3 New)
3 Comments

Avatar

Avatar

jsaeheng

Employee

Avatar

jsaeheng

Employee

jsaeheng
Employee

07-03-2018

ask and you shall receive, we are releasing this tomorrow  

Avatar

Avatar

AdamGreco

MVP

Avatar

AdamGreco

MVP

AdamGreco
MVP

10-03-2018

Unfortunately, the new functionality that was released doesn't solve this issue.  It only lets you divide two numbers in the same table.  I am looking to divide two summary metrics, which may come from different tables...

Avatar

Avatar

jsaeheng

Employee

Avatar

jsaeheng

Employee

jsaeheng
Employee

12-03-2018

Thanks for clarifying Adam.  Let me work with the team on this and we may reach out to you for some follow-up questions/ testing if that's okay.  Cheers!