Tech Articles


Data-Driven Column Gradient Bar


As of PowerBuilder 11.5, DataWindow columns have been able to have background gradients. In that gradients can be data-driven by expressions, this tip will review how columns can emulate bar graphs.

For this example, I’ve created a DataWindow object that displays sales orders by sales rep and I’ve created a computed field that displays each rep’s quantity of orders as a percentage compared to the total count of orders for all sales reps.

DataWindow Painter - Computed Field

To have the column’s background gradient behave as a bar in a bar graph, first institute the background gradient itself. Here I’ve chosen a horizontal gradient that will be blue in color.

Computed Field's Background Properties

Next, I’ve set the gradient’s Transparency, Angle and Focus to a value of zero, and the Scale to 100%.

Spread property of column background gradient

Now I’ll institute an expression for the gradient’s Spread. Here I’ve simply used the quantity of each rep’s orders.

Spread property value of the gradient

And now you have it. The column’s background gradient now has the column emulate a bar chart giving the user proportionate data visualization…with zero scripting!

Data visualization of percentages using a gradient is achieved

Comments (0)
There are no comments posted here yet

Find Articles by Tag

Service Graph 32-bit Event Handling SOAP RibbonBar Builder HTTPClient CrypterObject Authentication Database Table Schema Stored Procedure Deployment Source Code DataType Import Mobile Platform Design Export JSON Filter UI Themes RESTClient Debugging Interface Automated Testing JSONParser CoderObject Oracle REST API Database Painter RichTextEdit Control iOS SnapDevelop Resize Application Encryption TreeView Outlook Installation WinAPI DevOps Bug IDE Repository DataWindow JSON Migration C# PowerScript (PS) Azure Sort PowerServer Web Authorization Model Source Control SQL Server Database Table Data Performance Web API ODBC 64-bit TortoiseGit Window ActiveX Excel File PFC InfoMaker Windows 10 Icons Database Object External Functions COM PowerBuilder Compiler Branch & Merge Class Trial Database Connection Event Handler PostgreSQL Web Service Proxy Variable TLS/SSL Jenkins SqlModelMapper NativePDF OrcaScript MessageBox OLE GhostScript Script Linux OS Elevate Conference Text PDF Export SQL CI/CD PDFlib BLOB DLL Icon Testing .NET Assembly Android Charts Encoding PostgreSQL ODBC driver PowerBuilder (Appeon) Import JSON Transaction RibbonBar Array Error .NET Std Framework UI Open Source PBDOM Git Database Table SqlExecutor Messagging Database OAuth Expression DragDrop Menu Event Data SVN .NET DataStore License Debugger SDK XML JSONGenerator WebBrowser Syntax Debug Database Profile UI Modernization DataWindow Validation PowerBuilder TFS Windows OS Configuration OAuth 2.0 PowerServer Mobile SnapObjects JSON