5 Replies Latest reply on Nov 15, 2018 12:10 PM by Michael Ye

    Questions regarding filtering and count expression

    Ali Ahmad

      Hi there,

       

      I was wondering if anyone can point me in the direction of how do so that the Quarter filter I have also applies to Month? Do I need to make 3 differnet filters formatted differently based on date? I would think that when you chose Q1 it would indirectly remove the months that aren't connected to this and vise versa. Why is all months still chosen when I have picked Q1 and Q2?

       

      Tableau example.PNG

       

      And another thing I am wondering about is how I can count x amount of rows that contain text? Something like


      Sum(IF(IsNull(TextField),0,1))

       

       

       

      I just don't know how do to it in Tableau and when I search you get so many answers it's hard to know what actually is for your own challenge.

       

      Thanks for any help.

       

      Best,

       

      Ali A