Expand my Community achievements bar.

Join us at Adobe Summit 2024 for the Coffee Break Q&A Live series, a unique opportunity to network with and learn from expert users, the Adobe product team, and Adobe partners in a small group, 30 minute AMA conversations.

Write calculated metric formulas

Avatar

Level 2

8/7/17

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

4 Comments