Google Looker Studio: is there is a way to display scorecard with calculated "Top-#" item by points?

Question

I have:

1. Table in Google Sheets with some data, e.g.:

Item Name	Points
Item 1	100
Item 23	200 (this is the target)
Item 12	150

2. Dashboard that should display such scorecards:

---

---

Goal:

1. To display a top X item in the scorecard
2. Without modifying source table
3. In the real world it will use Data Ranges as well

Links:

1. Dashboard
2. Google Sheet

I manage to solve this via custom connector & Google Apps Script, but in this case I loose possibility to manage the calculation from the dashboard (and refresh time for custom connector is 12h VS default 15min for Google Sheets).

Maybe someone has better decision? Thanks in advance.

UPD 1:

1. My Community Connector refresh rate screen:
2. Some documentation about it

Answer 1

What you want to achieve is display the top-3 rankings in scorecards, correct?

From the report edit view, you can create new fields in your datasource to extract those values. There will still be a refresh time of 12h for the data incoming from Google Sheets, but that can be set to 15min as well.