How to get average on specific values in a table

[mahnoor1279]

Hey everyone I have data of transactions in which i want to get the average  only if the transaction_type =DEBIT_CARD 

[lironbaram]

Hi 
Something like this 

Avg(if(transaction_type='DEBIT_CARD',transaction_value))

[mahnoor1279]

can we apply the same technique for avg per day ?

[stevejoyce]

aggr(avg({<transaction_type = {'DEBIT_CARD'}>} transaction_value), day_field)