Write calculated metric formulas | Community
Skip to main content
adamw73247808
Level 2
August 7, 2017
New

Write calculated metric formulas

  • August 7, 2017
  • 4 replies
  • 4180 views

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.

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

4 replies

Urs_Boller
Community Advisor
Community Advisor
August 7, 2017

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

PradeepJaiswal
Level 3
May 23, 2018

This is good

jantzen_b
Adobe Employee
Adobe Employee
October 27, 2020
No text available
Community Manager
October 5, 2022
No text available