Column formattingSharePoint Online

Number Gauge

This sample demonstrates combining a fixed SVG (gauge background) with a dynamic SVG (needle). It makes understanding number columns (percent) very intuitive.

Get this format View on GitHub

Shared by Chris Kent
Updated Jul 10, 2019

Sample preview · View original image

Copy. Apply. Make it yours.

Get this format

2 definitions

Review the requirements below, then paste this JSON into the matching formatting panel. Show me where.

Use your list's internal column names and replace any tenant-specific URLs or flow IDs. Formatting is presentation, not a way to secure data.

Definition

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "attributes": {
    "title": "@currentField.displayValue"
  },
  "children": [
    {
      "elmType": "svg",
      "style": {
        "width": "60px",
        "height": "30px"
      },
      "children": [
        {
          "elmType": "path",
          "style": {
            "fill": "#d83b01"
          },
          "attributes": {
            "d": "M 51.198558,8.7668 37.946109,22.01479 a 11.251965,11.248175 0 0 1 3.300487,7.9486 H 60.000001 A 30.005242,29.995135 0 0 0 51.198558,8.7668 Z"
          }
        },
        {
          "elmType": "path",
          "style": {
            "fill": "#af3001"
          },
          "attributes": {
            "d": "m 37.946109,22.01479 -2.650577,2.64967 a 7.5013101,7.4987835 0 0 1 2.200471,5.29893 h 3.750593 a 11.251965,11.248175 0 0 0 -3.300487,-7.9486 z"
          }
        },
        {
          "elmType": "path",
          "style": {
            "fill": "#ffb900"
          },
          "attributes": {
            "d": "m 29.981693,1e-5 3e-6,18.73548 a 11.251965,11.248175 0 0 1 7.956202,3.2875 L 51.198558,8.7668 A 30.005241,29.995135 0 0 0 29.981693,1e-5 Z"
          }
        },
        {
          "elmType": "path",
          "style": {
            "fill": "#d89d00"
          },
          "attributes": {
            "d": "m 29.981696,18.73549 -7e-6,3.74721 a 7.5013098,7.4987833 0 0 1 5.30414,2.19147 l 2.652069,-2.65118 a 11.251965,11.248175 0 0 0 -7.956202,-3.2875 z"
          }
        },
        {
          "elmType": "path",
          "style": {
            "fill": "#bad80a"
          },
          "attributes": {
            "d": "M 8.7779576,8.79849 22.030411,22.04647 A 11.251965,11.248175 0 0 1 29.981693,18.7471 V 1e-5 A 30.005241,29.995135 0 0 0 8.7779576,8.79849 Z"
          }
        },
        {
          "elmType": "path",
          "style": {
            "fill": "#99b208"
          },
          "attributes": {
            "d": "m 22.030411,22.04647 2.650566,2.64969 a 7.5013098,7.4987833 0 0 1 5.300716,-2.19974 V 18.7471 a 11.251965,11.248175 0 0 0 -7.951282,3.29937 z"
          }
        },
        {
          "elmType": "path",
          "style": {
            "fill": "#107c10"
          },
          "attributes": {
            "d": "M 5.7294317e-6,29.99999 H 18.741802 a 11.251965,11.248175 0 0 1 3.288609,-7.95352 L 8.769752,8.79028 A 30.005241,29.995135 0 0 0 5.7294317e-6,29.99999 Z"
          }
        },
        {
          "elmType": "path",
          "style": {
            "fill": "#0b590b"
          },
          "attributes": {
            "d": "M 18.741802,29.99999 22.490276,30 a 7.5013098,7.4987833 0 0 1 2.192203,-5.30235 l -2.652068,-2.65118 a 11.251965,11.248175 0 0 0 -3.288609,7.95352 z"
          }
        },
        {
          "elmType": "path",
          "style": {
            "fill": "#000000"
          },
          "attributes": {
            "d": "m 29.994597,26.96385 a 3.0005242,2.9995135 0 0 0 -3.000562,2.99954 h 6.001125 a 3.0005242,2.9995135 0 0 0 -3.000563,-2.99954 z"
          }
        },
        {
          "elmType": "path",
          "style": {
            "fill": "#000000"
          },
          "attributes": {
            "d": "='M 28 29 L ' + toString(30+26*cos(3.14159265+3.14159265*if(@currentField>0.95,.95,if(@currentField<.05,.05,@currentField)))+if(@currentField < .5,-1,0)) + ' ' + toString(30+26*sin(3.14159265+3.14159265*if(@currentField>0.95,.95,if(@currentField<.05,.05,@currentField)))+if(@currentField < .25,2,0)) + ' L ' + toString(30+26*cos(3.14159265+3.14159265*if(@currentField>0.95,.95,if(@currentField<.05,.05,@currentField)))+if(@currentField > .5,1,0)) + ' ' + toString(30+26*sin(3.14159265+3.14159265*if(@currentField>0.95,.95,if(@currentField<.05,.05,@currentField)))+if(@currentField > .75,2,0)) +' L 32 29 Z'"
          }
        }
      ]
    }
  ]
}

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "attributes": {
    "title": "@currentField.displayValue"
  },
  "children": [
    {
      "elmType": "svg",
      "style": {
        "width": "60px",
        "height": "30px"
      },
      "children": [
        {
          "elmType": "path",
          "style": {
            "fill": "#d83b01"
          },
          "attributes": {
            "d": "M 51.198558,8.7668 37.946109,22.01479 a 11.251965,11.248175 0 0 1 3.300487,7.9486 H 60.000001 A 30.005242,29.995135 0 0 0 51.198558,8.7668 Z"
          }
        },
        {
          "elmType": "path",
          "style": {
            "fill": "#af3001"
          },
          "attributes": {
            "d": "m 37.946109,22.01479 -2.650577,2.64967 a 7.5013101,7.4987835 0 0 1 2.200471,5.29893 h 3.750593 a 11.251965,11.248175 0 0 0 -3.300487,-7.9486 z"
          }
        },
        {
          "elmType": "path",
          "style": {
            "fill": "#ffb900"
          },
          "attributes": {
            "d": "m 29.981693,1e-5 3e-6,18.73548 a 11.251965,11.248175 0 0 1 7.956202,3.2875 L 51.198558,8.7668 A 30.005241,29.995135 0 0 0 29.981693,1e-5 Z"
          }
        },
        {
          "elmType": "path",
          "style": {
            "fill": "#d89d00"
          },
          "attributes": {
            "d": "m 29.981696,18.73549 -7e-6,3.74721 a 7.5013098,7.4987833 0 0 1 5.30414,2.19147 l 2.652069,-2.65118 a 11.251965,11.248175 0 0 0 -7.956202,-3.2875 z"
          }
        },
        {
          "elmType": "path",
          "style": {
            "fill": "#bad80a"
          },
          "attributes": {
            "d": "M 8.7779576,8.79849 22.030411,22.04647 A 11.251965,11.248175 0 0 1 29.981693,18.7471 V 1e-5 A 30.005241,29.995135 0 0 0 8.7779576,8.79849 Z"
          }
        },
        {
          "elmType": "path",
          "style": {
            "fill": "#99b208"
          },
          "attributes": {
            "d": "m 22.030411,22.04647 2.650566,2.64969 a 7.5013098,7.4987833 0 0 1 5.300716,-2.19974 V 18.7471 a 11.251965,11.248175 0 0 0 -7.951282,3.29937 z"
          }
        },
        {
          "elmType": "path",
          "style": {
            "fill": "#107c10"
          },
          "attributes": {
            "d": "M 5.7294317e-6,29.99999 H 18.741802 a 11.251965,11.248175 0 0 1 3.288609,-7.95352 L 8.769752,8.79028 A 30.005241,29.995135 0 0 0 5.7294317e-6,29.99999 Z"
          }
        },
        {
          "elmType": "path",
          "style": {
            "fill": "#0b590b"
          },
          "attributes": {
            "d": "M 18.741802,29.99999 22.490276,30 a 7.5013098,7.4987833 0 0 1 2.192203,-5.30235 l -2.652068,-2.65118 a 11.251965,11.248175 0 0 0 -3.288609,7.95352 z"
          }
        },
        {
          "elmType": "path",
          "style": {
            "fill": "#000000"
          },
          "attributes": {
            "d": "m 29.994597,26.96385 a 3.0005242,2.9995135 0 0 0 -3.000562,2.99954 h 6.001125 a 3.0005242,2.9995135 0 0 0 -3.000563,-2.99954 z"
          }
        },
        {
          "elmType": "path",
          "style": {
            "fill": "#000000"
          },
          "attributes": {
            "d": "='M 28 29 L ' + toString(30+26*cos(3.14159265+3.14159265*if(@currentField>0.95,.95,if(@currentField<.05,.05,@currentField)))+if(@currentField < .5,-1,0)) + ' ' + toString(30+26*sin(3.14159265+3.14159265*if(@currentField>0.95,.95,if(@currentField<.05,.05,@currentField)))+if(@currentField < .25,2,0)) + ' L ' + toString(30+26*cos(3.14159265+3.14159265*if(@currentField>0.95,.95,if(@currentField<.05,.05,@currentField)))+if(@currentField > .5,1,0)) + ' ' + toString(30+26*sin(3.14159265+3.14159265*if(@currentField>0.95,.95,if(@currentField<.05,.05,@currentField)))+if(@currentField > .75,2,0)) +' L 32 29 Z'"
          }
        }
      ]
    }
  ]
}

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "attributes": {
    "title": "@currentField"
  },
  "children": [
    {
      "elmType": "svg",
      "style": {
        "width": "60px",
        "height": "30px"
      },
      "children": [
        {
          "elmType": "path",
          "style": {
            "fill": "#000000"
          },
          "attributes": {
            "d": "m 29.994597,26.96385 a 3.0005242,2.9995135 0 0 0 -3.000562,2.99954 h 6.001125 a 3.0005242,2.9995135 0 0 0 -3.000563,-2.99954 z"
          }
        },
        {
          "elmType": "path",
          "style": {
            "fill": "#c23800"
          },
          "attributes": {
            "d": "m 26.563585,19.290748 a 11.251965,11.248175 36 0 0 -5.65065,4.084052 l 3.03227,2.203073 a 7.5013097,7.4987832 36 0 1 3.775342,-2.72672 z"
          }
        },
        {
          "elmType": "path",
          "style": {
            "fill": "#ea4300"
          },
          "attributes": {
            "d": "M 20.776908,1.4816213 A 30.005242,29.995135 36 0 0 5.7503318,12.358524 L 20.912935,23.3748 a 11.251965,11.248175 36 0 1 5.650003,-4.085799 z"
          }
        },
        {
          "elmType": "path",
          "style": {
            "fill": "#d89d00"
          },
          "attributes": {
            "d": "m 33.540525,19.323632 a 11.251965,11.248175 72 0 0 -6.972018,-0.0173 l 1.158225,3.564647 a 7.5013097,7.4987832 72 0 1 4.657041,0.01313 z"
          }
        },
        {
          "elmType": "path",
          "style": {
            "fill": "#ffb900"
          },
          "attributes": {
            "d": "M 39.326947,1.514422 A 30.005242,29.995135 72 0 0 20.776908,1.4816213 l 5.791599,17.8247097 a 11.251965,11.248175 72 0 1 6.972521,0.01551 z"
          }
        },
        {
          "elmType": "path",
          "style": {
            "fill": "#99b208"
          },
          "attributes": {
            "d": "m 39.170837,23.435679 a 11.248175,11.251965 18 0 0 -5.630312,-4.112046 l -1.158224,3.564648 a 7.4987832,7.5013097 18 0 1 3.759908,2.747962 z"
          }
        },
        {
          "elmType": "path",
          "style": {
            "fill": "#bad80a"
          },
          "attributes": {
            "d": "M 54.320142,12.428898 A 29.995135,30.005242 18 0 0 39.332125,1.4989228 l -5.7916,17.8247092 a 11.248175,11.251965 18 0 1 5.631772,4.110893 z"
          }
        },
        {
          "elmType": "path",
          "style": {
            "fill": "#0c580c"
          },
          "attributes": {
            "d": "M 41.308854,30.071809 A 11.248175,11.251965 54 0 0 39.170836,23.43568 l -3.03227,2.203073 a 7.4987832,7.5013097 54 0 1 1.426617,4.433167 z"
          }
        },
        {
          "elmType": "path",
          "style": {
            "fill": "#107c10"
          },
          "attributes": {
            "d": "M 60.034523,30.071674 A 29.995135,30.005242 54 0 0 54.333441,12.419403 L 39.170837,23.435679 a 11.248175,11.251965 54 0 1 2.139877,6.636055 z"
          }
        },
        {
          "elmType": "path",
          "style": {
            "fill": "#b3292c"
          },
          "attributes": {
            "d": "m 18.774918,30.01093 a 11.251965,11.248175 36 0 1 2.138018,-6.636129 l 3.03227,2.203073 a 7.5013097,7.4987832 36 0 0 -1.426617,4.433167 z"
          }
        },
        {
          "elmType": "path",
          "style": {
            "fill": "#d13438"
          },
          "attributes": {
            "d": "M 0.049249,30.010795 A 30.005242,29.995135 36 0 1 5.750331,12.358524 L 20.912935,23.3748 a 11.251965,11.248175 36 0 0 -2.139877,6.636055 z"
          }
        },
        {
          "elmType": "path",
          "style": {
            "fill": "#000000"
          },
          "attributes": {
            "d": "='M 28 29 L ' + toString(30+26*cos(3.14159265+3.14159265*if(@currentField>0.95,.95,if(@currentField<.05,.05,@currentField)))+if(@currentField < .5,-1,0)) + ' ' + toString(30+26*sin(3.14159265+3.14159265*if(@currentField>0.95,.95,if(@currentField<.05,.05,@currentField)))+if(@currentField < .25,2,0)) + ' L ' + toString(30+26*cos(3.14159265+3.14159265*if(@currentField>0.95,.95,if(@currentField<.05,.05,@currentField)))+if(@currentField > .5,1,0)) + ' ' + toString(30+26*sin(3.14159265+3.14159265*if(@currentField>0.95,.95,if(@currentField<.05,.05,@currentField)))+if(@currentField > .75,2,0)) +' L 32 29 Z'"
          }
        }
      ]
    }
  ]
}

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "attributes": {
    "title": "@currentField"
  },
  "children": [
    {
      "elmType": "svg",
      "style": {
        "width": "60px",
        "height": "30px"
      },
      "children": [
        {
          "elmType": "path",
          "style": {
            "fill": "#000000"
          },
          "attributes": {
            "d": "m 29.994597,26.96385 a 3.0005242,2.9995135 0 0 0 -3.000562,2.99954 h 6.001125 a 3.0005242,2.9995135 0 0 0 -3.000563,-2.99954 z"
          }
        },
        {
          "elmType": "path",
          "style": {
            "fill": "#c23800"
          },
          "attributes": {
            "d": "m 26.563585,19.290748 a 11.251965,11.248175 36 0 0 -5.65065,4.084052 l 3.03227,2.203073 a 7.5013097,7.4987832 36 0 1 3.775342,-2.72672 z"
          }
        },
        {
          "elmType": "path",
          "style": {
            "fill": "#ea4300"
          },
          "attributes": {
            "d": "M 20.776908,1.4816213 A 30.005242,29.995135 36 0 0 5.7503318,12.358524 L 20.912935,23.3748 a 11.251965,11.248175 36 0 1 5.650003,-4.085799 z"
          }
        },
        {
          "elmType": "path",
          "style": {
            "fill": "#d89d00"
          },
          "attributes": {
            "d": "m 33.540525,19.323632 a 11.251965,11.248175 72 0 0 -6.972018,-0.0173 l 1.158225,3.564647 a 7.5013097,7.4987832 72 0 1 4.657041,0.01313 z"
          }
        },
        {
          "elmType": "path",
          "style": {
            "fill": "#ffb900"
          },
          "attributes": {
            "d": "M 39.326947,1.514422 A 30.005242,29.995135 72 0 0 20.776908,1.4816213 l 5.791599,17.8247097 a 11.251965,11.248175 72 0 1 6.972521,0.01551 z"
          }
        },
        {
          "elmType": "path",
          "style": {
            "fill": "#99b208"
          },
          "attributes": {
            "d": "m 39.170837,23.435679 a 11.248175,11.251965 18 0 0 -5.630312,-4.112046 l -1.158224,3.564648 a 7.4987832,7.5013097 18 0 1 3.759908,2.747962 z"
          }
        },
        {
          "elmType": "path",
          "style": {
            "fill": "#bad80a"
          },
          "attributes": {
            "d": "M 54.320142,12.428898 A 29.995135,30.005242 18 0 0 39.332125,1.4989228 l -5.7916,17.8247092 a 11.248175,11.251965 18 0 1 5.631772,4.110893 z"
          }
        },
        {
          "elmType": "path",
          "style": {
            "fill": "#0c580c"
          },
          "attributes": {
            "d": "M 41.308854,30.071809 A 11.248175,11.251965 54 0 0 39.170836,23.43568 l -3.03227,2.203073 a 7.4987832,7.5013097 54 0 1 1.426617,4.433167 z"
          }
        },
        {
          "elmType": "path",
          "style": {
            "fill": "#107c10"
          },
          "attributes": {
            "d": "M 60.034523,30.071674 A 29.995135,30.005242 54 0 0 54.333441,12.419403 L 39.170837,23.435679 a 11.248175,11.251965 54 0 1 2.139877,6.636055 z"
          }
        },
        {
          "elmType": "path",
          "style": {
            "fill": "#b3292c"
          },
          "attributes": {
            "d": "m 18.774918,30.01093 a 11.251965,11.248175 36 0 1 2.138018,-6.636129 l 3.03227,2.203073 a 7.5013097,7.4987832 36 0 0 -1.426617,4.433167 z"
          }
        },
        {
          "elmType": "path",
          "style": {
            "fill": "#d13438"
          },
          "attributes": {
            "d": "M 0.049249,30.010795 A 30.005242,29.995135 36 0 1 5.750331,12.358524 L 20.912935,23.3748 a 11.251965,11.248175 36 0 0 -2.139877,6.636055 z"
          }
        },
        {
          "elmType": "path",
          "style": {
            "fill": "#000000"
          },
          "attributes": {
            "d": "='M 28 29 L ' + toString(30+26*cos(3.14159265+3.14159265*if(@currentField>0.95,.95,if(@currentField<.05,.05,@currentField)))+if(@currentField < .5,-1,0)) + ' ' + toString(30+26*sin(3.14159265+3.14159265*if(@currentField>0.95,.95,if(@currentField<.05,.05,@currentField)))+if(@currentField < .25,2,0)) + ' L ' + toString(30+26*cos(3.14159265+3.14159265*if(@currentField>0.95,.95,if(@currentField<.05,.05,@currentField)))+if(@currentField > .5,1,0)) + ' ' + toString(30+26*sin(3.14159265+3.14159265*if(@currentField>0.95,.95,if(@currentField<.05,.05,@currentField)))+if(@currentField > .75,2,0)) +' L 32 29 Z'"
          }
        }
      ]
    }
  ]
}

.definition[hidden] { display:block !important; } .variant-chooser,[data-copy] { display:none; }All definitions are shown below. Select the code manually or download the JSON file.

From the contributor

How to use this sample

Summary

This sample demonstrates combining a fixed SVG (gauge background) with a dynamic SVG (needle). It makes understanding number columns (percent) very intuitive.

screenshot of the sample

An alternate version (number-gauge-reversed) has been provided for scenarios where the gauge background should be reversed (green to red).

screenshot reversed

View requirements

This format can be applied to a Number column. It is expected that the values will be from 0 to 1 (percent)

Sample

Solution	Author(s)
number-gauge.json	Chris Kent
number-gauge-reversed.json	Chris Kent

Version history

Version	Date	Comments
1.0	July 10, 2019	Initial release

Disclaimer

THIS CODE IS PROVIDED AS IS WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING ANY IMPLIED WARRANTIES OF FITNESS FOR A PARTICULAR PURPOSE, MERCHANTABILITY, OR NON-INFRINGEMENT.

Additional notes

Use column formatting to customize SharePoint

Get this format

How to use this sample

Summary

View requirements

Sample

Version history

Disclaimer

Additional notes

More formats like this

Doughnut Chart

Monthly Gantt Chart

Format a column with multi-path SVGs