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.
