<< SharePoint 2019 'Modern' Web PartsTable of contents 
SQL Gauge Web Part

The SQL Bullet Graph Gauge Web Part allows to display data values from the specified SQL Server database, OLE-DB or ODBC data source as either a KPI indicator, a Bullet Graph or a gauge.
For configuration details see also /apps/page.asp?Q=5782
Sharepoint 2019 SQL Gauge Web Part

Web Part Configuration:

enter the optional web part title

Web Part:

enter the below configuration options:

connection=enter the database connection string
pwd=enter the connection password
query=enter the SQL query
rangevalues=enter the values for the KPI ranges
rangecolors=enter the RGB values for the KPI range colors
type=Gauge (choose one of the available KPI types)
caption=enter the optional chart caption
captioncss=enter the caption CSS styles
width=150 (enter the chart width in pixels)
kpilabels=Goal;actual (enter the KPI labels)
precision=2 (set the values's number of decimal places)

Web Part Configuration

Please enter a comment below if you want to give feedback or have suggestions for improvements:

User Comments Post a Comment