Forum Discussion
Getting the % of specific values within a Column
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.
mglomb , try a measure like
divide(countrows(filter(table, table[score]>= 8 && table[score]<=10)),coutrows())
2 Replies
- amitchandak
Super User
mglomb , try a measure like
divide(countrows(filter(table, table[score]>= 8 && table[score]<=10)),coutrows())
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?
