Level 1

0% to

Level 2

Tip /

to gain points, level up, and earn exciting badges like the new
Mission!

View all

## Divide/Multiply/Add/Subtract Analysis Workspace Summary Metrics

Level 6

Likes

101 likes

Total Posts

64 posts

30 solutions
View profile

Level 6

Likes

101 likes

Total Posts

64 posts

30 solutions
View profile
Level 6

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.

jsaeheng
Employee

Likes

0 likes

Total Posts

5 posts

0 solutions
View profile

jsaeheng
Employee

Likes

0 likes

Total Posts

5 posts

0 solutions
View profile
jsaeheng
Employee

07-03-2018

Level 6

Likes

101 likes

Total Posts

64 posts

30 solutions
View profile

Level 6

Likes

101 likes

Total Posts

64 posts

30 solutions
View profile
Level 6

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...

jsaeheng
Employee

Likes

0 likes

Total Posts

5 posts

0 solutions
View profile

jsaeheng
Employee

Likes

0 likes

Total Posts

5 posts

0 solutions
View profile
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!