Working with the SQL Template Designer > Example of a Gauge Chart SQL Template: Allocated Capacity
  
Version 10.0.01
Example of a Gauge Chart SQL Template: Allocated Capacity
Use the following example to identify the properties to be configured in the SQL Template Designer.
1. For this particular example, a basic query was used:
SELECT
SUM(raw_allocated_gb/1024) AS raw_allocated_tb,
SUM(raw_capacity_gb/1024) As raw_capacity_tb
FROM aps_v_storage_array
2. In the Formatting tab, configure the Formatter and Pattern to include the unit of measure for the values represented in the gauge.