Join our Community in its new Home - The Datorama Trailblazer Community Group!

It's been an amazing 3 years coming together in this forum to collaborate, innovate, support, and inspire each other about our shared usage of Datorama. While this is not quite a goodbye, we are excited to announce that we are getting a fresh start in our new home within the Salesforce Trailblazer Community. We have a ton of fun new content planned and you may even see the revival of some of our most popular posts from the past few years.

We’ll be keeping this group around for a bit for you to peruse, but as of November 15, we will no longer be allowing new posts or comments. Be sure to join our new group at https://www.salesforce.com/success-datorama to keep the conversation going.

We can’t wait to see you there!

Bring Back the Blanks!!!

KishanPatelKishanPatel London - Salesforce TowerSYS_ADMIN IMG42

Have you ever had blank values in dimension filers and wondered why they don’t show up as a selection? Even though you have checked to see that those blanks definitely exist and they also show up in your pivot tables and other widgets but just not in your filters. 

The reason for “Blank” values not to show up in a filter normally is due to the fact that there are no values for it to be referenced too and therefore no “Blanks” are displayed. 


Solution:

Since it is empty we don’t have a value to try and look at to select on a filter, and therefore we would have to assign these blanks a value.

A simple IF ELSE calculated dimension would do the trick. You can either apply this formula directly in the mapping our create a calculated dimension. 

Example: 

Lets say “Dim_X” has some blank values we can apply the following simple formula to “Dim_X” 

if(ISEMPTY([Dim_X]))

    {

        "(Blank)";

    }

else

    {

        [Dim_X];

    }

By applying the above you are assigning the blank values  the following   "(Blank)”, which in turn brings back the blanks in your filters. 

Sign In or Register to comment.