Division in Beastmode

user082291
user082291 ⚪️
in Charting

I am trying to find the percentage of data in 1 column.

I have a field called Anonymous that is either a Yes or No. Would like to show the percentage of when the anonymous is yes on a line graph

I know the equation is Yes/Yes and No but can't get it to work in beast mode

Tried this

count('anonymous' = 'yes')/count('anonymous' = 'yes' or 'no')

I know I'm way off. Thank you, Jill Bowers

Answers

  • GrantSmith
    GrantSmith 🥷

    Hi @user082291

    You can use SUM and a CASE statement to conditionally calculate your percentage. 


    SUM(CASE WHEN `anonymous`='yes' THEN 1 ELSE 0 END) / SUM(CASE WHEN `anonymous` IN ('yes', 'no') THEN 1 ELSE 0 END)


    The denominator case statement isn't required if your values are only 'yes' or 'no'. You could change that to just be SUM(1)

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Categories