Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!

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