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

Write calculated metric formulas

Avatar

Avatar
Contributor
Level 2
adamw73247808
Level 2

Likes

20 likes

Total Posts

11 posts

Correct reply

0 solutions
Top badges earned
Contributor
Shape 1
Boost 5
Boost 3
Boost 10
View profile

Avatar
Contributor
Level 2
adamw73247808
Level 2

Likes

20 likes

Total Posts

11 posts

Correct reply

0 solutions
Top badges earned
Contributor
Shape 1
Boost 5
Boost 3
Boost 10
View profile
adamw73247808
Level 2

07-08-2017

I would like the ability to write calculated metrics. This is for two reasons:

  1. I'm used to writing long formulas, nesting conditions and operators. I'll brave a sweeping statement that most analysts are famiiliar with this too
  2. The UI for the calculated metric builder is not space efficient at all. As soon as your calculated metric definition goes below the fold of your screen, it becomes very hard to manage

Perhaps the requirement for #1 can be resolved by simply improving the UI as mentioned in #2, however, I'd still like the ability to write formulas out. I see it working like:

  • Start typing name of metric e.g. "uniq"
  • UI predicts "Unique Visitors", and maybe some dimensions, segments, time ranges and other metrics
  • I hit tab to select the top result
  • I can type an operator (-+/*)
  • I can simply type a fixed number
  • I can navigate within the formula bar using arrow keys to wrap items in parentheses / brackets as needed
  • Some method to wrap items within a segment

Below is an example of not the most extreme calculated metric, but certainly a metric that is not easily managed, edited or read. I've zoomed out to fit it on the screen.

1273880_pastedImage_1.png

Here's how much I can see at normal resolution:

1273881_pastedImage_2.png

3 Comments

Avatar

Avatar
Coach
Community Advisor
Urs_Boller
Community Advisor

Likes

530 likes

Total Posts

1,024 posts

Correct reply

257 solutions
Top badges earned
Coach
Bedrock
Contributor 2
Originator
View profile

Avatar
Coach
Community Advisor
Urs_Boller
Community Advisor

Likes

530 likes

Total Posts

1,024 posts

Correct reply

257 solutions
Top badges earned
Coach
Bedrock
Contributor 2
Originator
View profile
Urs_Boller
Community Advisor

07-08-2017

i would be happy to see a better layout of the CMbuilder, fully agree with the idea.

Avatar

Avatar
Give Back 10
Level 3
pradeep_jaiswal
Level 3

Likes

12 likes

Total Posts

33 posts

Correct reply

0 solutions
Top badges earned
Give Back 10
Ignite 10
Ignite 5
Ignite 3
Give Back 5
View profile

Avatar
Give Back 10
Level 3
pradeep_jaiswal
Level 3

Likes

12 likes

Total Posts

33 posts

Correct reply

0 solutions
Top badges earned
Give Back 10
Ignite 10
Ignite 5
Ignite 3
Give Back 5
View profile
pradeep_jaiswal
Level 3

23-05-2018

This is good

Avatar

Avatar
Give Back 1000
Level 10
jantzen_belliston-Adobe
Level 10

Likes

358 likes

Total Posts

2,372 posts

Correct reply

823 solutions
Top badges earned
Give Back 1000
Give back 900
Give Back 800
Give Back 700
Give back 600
View profile

Avatar
Give Back 1000
Level 10
jantzen_belliston-Adobe
Level 10

Likes

358 likes

Total Posts

2,372 posts

Correct reply

823 solutions
Top badges earned
Give Back 1000
Give back 900
Give Back 800
Give Back 700
Give back 600
View profile
jantzen_belliston-Adobe
Level 10

27-10-2020

 
Status changed to: Archived