If else statement in direct discovery

[#1]

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.