Getting the % of specific values within a Column

[mglomb]

I have a database, where one of the columns shows scores between 0-10.

While creating a dashboard with graphics, I want to show what % of that column represents the scores between 8-10.

Ex. If I have 10 rows, and 8 of them are scores 8-9-10, I want the final product to be 80%.

How do I do that? I've tried several methods and I was not able to.

Thanks in advance for the support.

[amitchandak · Accepted solution]

@mglomb , try a measure like

divide(countrows(filter(table, table[score]>= 8 && table[score]<=10)),coutrows())

[mglomb]

Hi, I've checked and it didn't work. Maybe I'm doing something wrong, so let me add pictures to help you to help me 🙂

Up to the expression of <=10, it's working fine, but trying to add the countrows after will give the error message you can see here. Thoughts?