Highlight top N rows in a table

[Jocke]

Hello

I have a pretty simple table with names and scores, but I would like to visualize who is in the current top 5.

In sheets this could be done by changing the cell border between row 5 and 6, or some conditional formatting with a custom formula.

But I can't find a way to replicate this within Data Studio. I would appreciate any idea. Maybe there is some obvious solution I'm blind to at the moment.

[Marcos Alcozer]

One idea is to have two tables with the first one configured to only show 5 results per page and pagination disabled. You chould then conditionally format those rows or include a table header that notes they are the top 5.

Marcos

--
You received this message because you are subscribed to the Google Groups "Data Studio in Education" group.
To unsubscribe from this group and stop receiving emails from it, send an email to googleschool-data...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/googleschool-datastudio/258e4ec1-fbcc-4eb7-a2a5-e355aebb5d10n%40googlegroups.com.

[Paczkowski, Kyle]

We do something like this with a hidden calculated metric that will rank the rows and then we have a filter on our chart to only display the top 20. 

Our ranking calculation is done in our data source, big query. What type of data connection are you using?

Kyle Paczkowski

Data Quality Analyst

Office of Data and Accountability | Boston Public Schools  

2300 Washington Street, Boston MA 02119

kpacz...@bostonpublicschools.org

Data Request Form

To view this discussion on the web visit https://groups.google.com/d/msgid/googleschool-datastudio/CAAJZMmynSemgx9F5HA7x69Jd8GHZZ_EdtZMy%3DyzpUE81qq%2BdKQ%40mail.gmail.com.

[Jocke]

That's true. Thanks for the tip.

[Jocke]

Just sheets at the moment, this is just a small project.