3 Replies Latest reply on Jul 24, 2018 8:24 AM by Karthikeyan Masialamani

# Crispy - Min(1), Avg(0), Sum(0) - Tricks

I read in some articles about the trick of  Min(1), Avg(0), Sum(0) and Avg(1).

I can understand that Min(1) = 1 , Avg(0) = 0 , Sum(0) = 0 and Avg(1) = 1, no different value will be retrieved.

instead of using like this, why can't we use simply 1 or 0 directly ? why we are use aggregate function here? to make it as Discrete and need of axis build ?

what I read is Min(1) will operate for each and every row, say for example to change the color of each row, we have to use Min(1).

How Min(1) work for single row?

I have lot of dots with doubt, can anybody help to connect all the dots so that my doubt should fly away.

• ###### 1. Re: Crispy - Min(1), Avg(0), Sum(0) - Tricks

any real time scenario/use case would really help to leverage my understanding?

• ###### 2. Re: Crispy - Min(1), Avg(0), Sum(0) - Tricks

Ken

can you also look into it and provide your valuable information