Custom expression to find median

[Himani Joshi]

Hi team,

I am trying to write a custom expression in a visualization to find the median.

So far, I have written this, but it shows an error. I was hoping you could help me out. Thanks !

case

WHEN(UniqueCount([Project-]='Even' THEN[Time (Hours)]=(1/2)*(UniqueCount([Project-])/2)+(UniqueCount([Project-])+1)/2))

WHEN(UniqueCount([Project-]='Odd' THEN [Time (Hours)]= (UniqueCount([Project-])/2)

ELSE "NULL"

END

[Gaia Paolini]

I don't understand what UniqueCount(..)='Even' means. UniqueCount produces a number. In terms of syntax, there is a missing ) before the ='Even' and ='Odd' parts.

 

Can you share what you are expecting to see as results

 

Gaia

[Himani Joshi]

Hi Gaia,

 

Thank you for your response, uniquecount is number of observations , 'n'. Thank you for pointing out the mistake in syntax , I will fix it right away.

 

 

 

Regards,

 

Himani

[Kirsten Smith (she/her)]

Did that fix the error If not, please include the error you are getting.