Handling 0 Results on Metric Set Filtering

#1

Hi all!

Hoping to poll the experts to see how you handle the following situation:

A data cube returns results to a simple data label metric set returning a count. For example, let’s say the cube is returning:
1, Apple
2, Banana
3, Coconut
…and the metric set is just a data label of count(Column2).

How then do we handle a situation where we want a count where Column2 = Donut? Right now, I have a data cube for each metric set doing the filtering and the metric sets set up to transform source nulls to zeros, but that’s not exactly elegant as it means dozens of extra objects to maintain. However, if I put the filter directly on the metric set, it’s not technically receiving a source null, so it spits out “No Data Returned” instead of “0”.

Hopefully others have faced this and come up with ingenious solutions, or maybe just found checkboxes that I’ve not yet clicked. :wink:

Thanks in advance! You’re all amazing!

#2

Hi Matt,

The behaviour is definitely what should be expected since it really isn’t a zero, it’s a nothing - math people get mad when you ignore the difference! :slight_smile:

but… i get what you are asking and it’s reasonable!! The problem that you are going to face is that the “no data returned” message is an overlay, not an actual data result. This overlay is simply displayed when nothing is return and it’s not the visualization control that is presenting this ‘data’. Try this to both remove the overlay and change what is displayed:

No%20Data%20Solution
No Data Solution.gif1920×1040 1.4 MB

Hope this helps

1 Like
#3

Love it! Exactly my feelings sometimes

1 Like
#4

That did the job perfectly! Thanks so much, Jeff!