Forum Discussion

brendaivett's avatar
brendaivett
Advocate II
9 years ago
Solved

How to not count the null/empty value in visualizations

Hi,   I just noticed that in my visualizations, when I use the Count Distinct to display values, it's actually counting one more for the Null/Empty values. I tried making the values "" or Null, fro...
Need Help
Tips and Tricks
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    brendaivett

     

    A fast way is add the column in visual level filter and unselected Blank.

     

Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

brendaivett

 

A fast way is add the column in visual level filter and unselected Blank.

 

sajidhussain's avatar
sajidhussain
Frequent Visitor
8 years ago

Hi Vvelarde

 

I am using calculated measure and this filtering is not working .

 

Could you please help ?

 

Sajid

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    i'm in the same situation of this post and it seems there is no solution yet

     

    basically the COUNT DISTINCT in the graphs sums also the BLANK even if i was able to subtract them from the table!