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

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