Forum Discussion

MaliniBaktha's avatar
MaliniBaktha
Icon for Helper II rankHelper II
2 years ago
Solved

filter in a column filter all category except one

 Hi,  I have a column with different category, but I want to do the counts of all the category except one how do I do that ?  I want to do the count of all category in channel_fourth except No Enco...
Need Help
Show and Tell
Tips and Tricks
  • christinepayton's avatar
    christinepayton
    2 years ago

    Yes, typically something like calculate(count(tab[Channel_fourth]),tab[channel_fourth]<> "No Encounters"). The calculate function accepts filters after the expression, and <> is your "not equals". Make sure to use double quotes on the text value, not single quotes. 

christinepayton's avatar
christinepayton
Icon for Most Valuable Professional rankMost Valuable Professional
2 years ago

Yes, typically something like calculate(count(tab[Channel_fourth]),tab[channel_fourth]<> "No Encounters"). The calculate function accepts filters after the expression, and <> is your "not equals". Make sure to use double quotes on the text value, not single quotes. 

  • MaliniBaktha's avatar
    MaliniBaktha
    Icon for Helper II rankHelper II
    2 years ago

    Thanks Christin, calculate worked