5 Replies Latest reply: Mar 12, 2018 4:34 AM by Manish Kachhia RSS

    How to add one more condition to Count(distinct(Date_visit_))

    Yeo Poh sai

      Hi All

       

      I have a chart with below expression working fine :-

       

      Count(distinct(Date_visit_))

       

      Now i like to add filter :-

      Date_year =2018

       

      I have try below :-

       

      Count(if(Date_year="2018",distinct(Date_visit_)))

       

       

       

       

      it display null

       

      Paul Yeo