2 Replies Latest reply on Oct 6, 2016 7:00 AM by Luciano Vasconcelos

    help with expression

    archana.chandra

      I'm trying to calculate percentage from the below expression . the logic  goes like count( grp 1)/ total count . but im not getting the result I'm missing something here which I'm not able to figure out.  I'm new to tableau any help will be appreciated.

       

       

      (if [MonthYear]>=[start date parameter] and [MonthYear] <= [End date Parameter]

      and

        [grp1]= 1 or [grp1]= 2 or [grp1]= 3

      then

        [user ID]

      END)

      /if [Indicator]='Y' then [user ID] END