Dynamic Text Editor

Dynamic text is user-built data-driven text that is linked to a data discovery. The text includes dynamic PQL or MDX functions in order to obtain and display the required information. When the presentation is launched in runtime, the dynamic text is rendered, showing the current data-driven values of the given dynamic functions.

Dynamic text is constructed in the Dynamic Text Editor in Present, Publish, or Illustrate.

Navigate the Dynamic Text Editor

With your text box selected, click the Dynamic Text button (purple highlight below) to open the Dynamic Text Builder. Alternatively, open the Dynamic Text drop-down button to build dynamic place holders, or add dynamic text fields.

From the Dynamic Text Editor:

  1. Open the Content drop-down (orange highlight below), find and select the content you want to base your dynamic text on. You must select a grid from a Discovery or a Visual Area from a Tabulation.
    • Tabulate allows you to blend queries from multiple data sources into a single grid, enabling the dynamic text to be based on multiple data sources. Note that you must save the grid from Discovery or the Visual Area in the Tabulation in order to use it in an Illustrate item. Once selected, the grid or visual area will appear in the editor.
  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,

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 AI-Driven ChatGPT PQL Function

Pyramid's Generate AI 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 AI-driven ChatGPT PQL function (from the Common PQL functions) to generate dynamic text. While this function cannot tell you about your data set, it can add additional information and background to your presentation. You can also use your data to drive the results generated by an LLM such as OpenAI's ChatGPT by creating interactions between visualizations or slicers, and the dynamic text where the ChatGPT PQL function is injected.

Warning: AI-generated assets are generated from public domain algorithms, which can produce both erroneous and inconsistent or 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.