Expand my Community achievements bar.

Divide/Multiply/Add/Subtract Analysis Workspace Summary Metrics

Avatar

Level 6

3/6/18

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.

5 Comments

Avatar

Level 6

3/10/18

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

Employee

3/12/18

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!

Avatar

Level 1

5/19/22

If we have a two traffic variables which is having data like time in and time out , can we get the total time (time out-time in) user staying in the app while creating reports in workspace. 

Avatar

Level 1

6/8/23

Hi, any update on Adam Greco's question? I have the same requirement - dividing 2 numbers that come from separate tables..