Skip to main content
Level 3
Dec 29, 2017 2:36 PM UTC
New

NULL Function in Calculated Metrics

I LOVE the calculated metric builder and I've started using some of the more advanced functions to start producing some much more useful interactive Workspaces. One wall I've hit though is that if I want to create a table of top products that match metric criteria such as "show me conversion for products with more than 1000 visits" when I rank in the opposite direction all I get is 0%. While this is technically accurate it means I can't create a table of those top products I'm just ranking the most relevant ones at the top.

The reason for this is the false value of the function is 0 which is still interpreted as a value and therefore displayed in the report, what I want to be able to do is set it to NULL instead so that if I sort by that metric ONLY those products are displayed and everything with no value is hidden.

5 replies

Level 2
Dec 29, 2017 4:09 PM UTC

It would be so helpful if I could rank products bottom to top by conversion, but only those that have reached a certain level of traffic!

Translate
Adobe Employee
Jan 4, 2018 4:27 AM UTC

Great suggestion - we will consider for a future release.  On a related note, we are also working on a feature to allow you to filter metrics by other metrics (such as your example above).

Translate
d1g1talAuthor
Level 3
Jan 4, 2018 7:28 AM UTC

Thanks Brandon, I look forward to it!

Translate
jantzen_b
Adobe Employee
Adobe Employee
Oct 27, 2020 10:54 PM UTC
No text available
Translate
Community Manager
Oct 5, 2022 7:04 PM UTC
No text available
Translate