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

NULL Function in Calculated Metrics

Avatar

Avatar
Give Back
Level 4
trucallinglife
Level 4

Likes

60 likes

Total Posts

29 posts

Correct reply

0 solutions
Top badges earned
Give Back
Boost 50
Boost 5
Boost 3
Boost 25
View profile

Avatar
Give Back
Level 4
trucallinglife
Level 4

Likes

60 likes

Total Posts

29 posts

Correct reply

0 solutions
Top badges earned
Give Back
Boost 50
Boost 5
Boost 3
Boost 25
View profile
trucallinglife
Level 4

29-12-2017

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.

4 Comments

Avatar

Avatar
Give Back 5
Level 3
KatieC1503
Level 3

Likes

19 likes

Total Posts

22 posts

Correct reply

2 solutions
Top badges earned
Give Back 5
Ignite 5
Give Back 3
Give Back
Ignite 3
View profile

Avatar
Give Back 5
Level 3
KatieC1503
Level 3

Likes

19 likes

Total Posts

22 posts

Correct reply

2 solutions
Top badges earned
Give Back 5
Ignite 5
Give Back 3
Give Back
Ignite 3
View profile
KatieC1503
Level 3

29-12-2017

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!

Avatar

Avatar
Employee
Brandon_George_
Employee

Likes

0 likes

Total Posts

179 posts

Correct reply

0 solutions
View profile

Avatar
Employee
Brandon_George_
Employee

Likes

0 likes

Total Posts

179 posts

Correct reply

0 solutions
View profile
Brandon_George_
Employee

03-01-2018

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).

Avatar

Avatar
Give Back
Level 4
trucallinglife
Level 4

Likes

60 likes

Total Posts

29 posts

Correct reply

0 solutions
Top badges earned
Give Back
Boost 50
Boost 5
Boost 3
Boost 25
View profile

Avatar
Give Back
Level 4
trucallinglife
Level 4

Likes

60 likes

Total Posts

29 posts

Correct reply

0 solutions
Top badges earned
Give Back
Boost 50
Boost 5
Boost 3
Boost 25
View profile
trucallinglife
Level 4

03-01-2018

Thanks Brandon, I look forward to it!

Avatar

Avatar
Give Back 1000
Level 10
jantzen_belliston-Adobe
Level 10

Likes

359 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

359 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