Hi Michael,
You should be able to do this using the Time Series Visual Builder.
If you choose "gauge", then "panel options", you can specify "1" as your max value. Then in your gauge data settings, you can compute the dynamic ratio per table. Here's a screenshot of a similar setup:
Hope that helps!