Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to count the number of distinct sales per day and per costumer, but only if it is a sale per telephone.
Therefore I need to make this expression to be conditional of sale per telephone:
Sum(Aggr(count (distinct sale), Date, costumer) )
Hi @Qliksense_77 ,
Of course I don't know exactly your field names but you can try something as below:
=Sum( Aggr( count( {< sales_type = {'telephone'} >} distinct sale), Date, costumer ) )
I hope it can helps.
Best Regards
Hi @Qliksense_77 ,
Of course I don't know exactly your field names but you can try something as below:
=Sum( Aggr( count( {< sales_type = {'telephone'} >} distinct sale), Date, costumer ) )
I hope it can helps.
Best Regards
It works:)