Divide/Multiply/Add/Subtract Analysis Workspace Summary Metrics | Community
Skip to main content
AdamGreco
Level 4
March 6, 2018
New

Divide/Multiply/Add/Subtract Analysis Workspace Summary Metrics

  • March 6, 2018
  • 6 replies
  • 8860 views

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.

6 replies

jsaeheng
Adobe Employee
Adobe Employee
March 7, 2018

ask and you shall receive, we are releasing this tomorrow  

AdamGreco
AdamGrecoAuthor
Level 4
March 10, 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...

jsaeheng
Adobe Employee
Adobe Employee
March 12, 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!

May 19, 2022

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. 

New Member
June 8, 2023

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

June 26, 2024

This would be a very useful feature