Create a gauge that pla from single cell

Looker Q&A Looker Studio
1

Hi, I’d like to create a gauge for the number of tickets sold for an event of the target.

The target is 50. The total number sold is already updated daily on a Google sheet in one specific cell. I have already added the Google sheet as a data source. However I can’t work out how to make sure the gauge is pulling the number sold from a specific cell.

2

If you are updating the the data in google sheets in a specific cell you need to make sure that the number being displayed in the Gauge is the actual number that is been entered on sheet if that is matched you can then change the number and refresh the data on sheet (ctrl+E ) or reconnect the data once the sheet is updated