0 Replies Latest reply: May 22, 2014 9:31 PM by Faizurimawaty Padzilah RSS

    If else statement in direct discovery

    Faizurimawaty Padzilah

      Hi All,

       

      Can we apply any if else statement or case when condition inside direct query?

      I realized if we apply if else statement in front end expression,we need to add dimension use in the expression.

      For example if(Counter='A',count(Ticket),0), in order to create a chart show no of ticket by Month, we need to add Counter in Dimension tab which is not suppose to.