Build Dynamic Images

Dynamic Images or "Infographics" give users the ability to create data-driven infographics. These infrographics can then be added to presentations and reports, where they can be configured to use data interactions from other artifacts - grids, charts, slicers and variables - to create responsive graphical displays of information that are more intuitive to understanding the underlying analysis, and are interactive for the end user.

Dynamic images may be based on the box stock images available in Illustrate, or on images that you import. For details about importing your own images, click here.

Dynamic PQL Functions
  • Click here to read about how to configure dynamic PQL functions in Illustrate
  • Click here to review the dynamic PQL functions in Illustrate

Image Properties

To construct a dynamic image, you must configure at least one of its dynamic properties (yellow highlight below). These properties can be used to drive the image color, show or hide the image, or drive its size, rotation, or volume.

  • Click here to learn more about the dynamic image properties.

Set Dynamic Image Properties

Dynamic images are configured by injecting values from the Dynamic Text Editor into the relevant properties (yellow highlight above). To open the editor:

  1. Add an image to the canvas.
  2. With the image selected (red highlight below), go to the Properties panel.
  3. Enable and configure the property that you want to make dynamic.

Set the Actual Value (that is, the value that drives the dynamic text) via the Dynamic Text Editor (purple highlight below). The Condition, Minimum, or Maximum values, may be driven by a given static value or by a dynamic formula configured via the text editor.

  • Click here to learn about the dynamic text properties.

Navigate the Dynamic Text Editor

The Dynamic Text Editor is used to configure dynamic formulas that will then drive the selected dynamic property for your image.

From the Dynamic Text Editor:

  1. Open the Content drop-down (orange highlight below), find and select the grid you want to base your dynamic formula on. You must select a grid from a Discovery or a Visual Area from a Tabulation.
  2. Write your dynamic text expression in the script editor (red highlight).
    • Use the PQL Functions library (yellow highlight) to add SQL expressions to your script.
    • Select the relevant cells from the grid (purple highlight) to populate the given PQL expressions,

Dynamic PQL Functions

The Pyramid Query Language or PQL (pronounced 'Prequel') is a language built into Pyramid's PYRANA engine to allow users to construct queries that can run against the many SQL data stacks that Pyramid can query natively. PQL includes a vast array of operations and functions that allows users to query data and build analytical logic.

The Dynamic Text Editor exposes Dynamic and Common functions. Dynamic functions are a set of specialized method that are designed to act on a given query's result set. Common functions are a set of methods that are found in most programmatic and mathematical function libraries. These functions are used to perform logic on basic data without concern for data structures, context, or even source.

To add a PQL function from the library to the script editor, simply double click on it. You will then need to inject values into the function.

Using the ChatGPT AI-Driven PQL Function

Pyramid's OpenAI integration enables you to use AI to generate scripts and images, dynamic text and infographics, calculations and lists, schedules, colors, and more. This allows you to generate a range of content, including complex code, by simply providing a text prompt.

Use the ChatGPT AI-driven PQL function (from the Common PQL functions) to generate dynamic text in your custom tooltip. While this function cannot tell you about your data set, it can add additional information and background to your presentation or publication.

Warning: AI-generated assets are generated from public domain algorithms, which can produce both erroneous and inconsistent/ random results. Use at your own risk.


Using Tabulate for Multiple Source Grids

Users requiring dynamic text from disparate data based on multiple queries can use Tabulate as the source for the dynamic text. Tabulate allows you to blend queries from multiple data sources into a single Tabulation. You must then define a Visual Area that can be used as a single data source for the dynamic text. The Visual Area can then be used as a source for the data grid that the dynamic text is based on.