Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

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

Learn more

View all

Sign in to view all badges

Divide/Multiply/Add/Subtract Analysis Workspace Summary Metrics

Avatar

Avatar
Boost 100
Level 6
AdamGreco
Level 6

Likes

100 likes

Total Posts

64 posts

Correct reply

30 solutions
Top badges earned
Boost 100
Give Back 50
Ignite 3
Give Back 25
Give Back 10
View profile

Avatar
Boost 100
Level 6
AdamGreco
Level 6

Likes

100 likes

Total Posts

64 posts

Correct reply

30 solutions
Top badges earned
Boost 100
Give Back 50
Ignite 3
Give Back 25
Give Back 10
View profile
AdamGreco
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.

3 Comments

Avatar

Avatar
Employee
jsaeheng
Employee

Likes

0 likes

Total Posts

5 posts

Correct reply

0 solutions
View profile

Avatar
Employee
jsaeheng
Employee

Likes

0 likes

Total Posts

5 posts

Correct reply

0 solutions
View profile
jsaeheng
Employee

07-03-2018

ask and you shall receive, we are releasing this tomorrow  

Avatar

Avatar
Boost 100
Level 6
AdamGreco
Level 6

Likes

100 likes

Total Posts

64 posts

Correct reply

30 solutions
Top badges earned
Boost 100
Give Back 50
Ignite 3
Give Back 25
Give Back 10
View profile

Avatar
Boost 100
Level 6
AdamGreco
Level 6

Likes

100 likes

Total Posts

64 posts

Correct reply

30 solutions
Top badges earned
Boost 100
Give Back 50
Ignite 3
Give Back 25
Give Back 10
View profile
AdamGreco
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...

Avatar

Avatar
Employee
jsaeheng
Employee

Likes

0 likes

Total Posts

5 posts

Correct reply

0 solutions
View profile

Avatar
Employee
jsaeheng
Employee

Likes

0 likes

Total Posts

5 posts

Correct reply

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!